nickwood1066
Board Regular
- Joined
- Aug 21, 2009
- Messages
- 55
Hi,
I have the formula below in my spreadsheet (excel 2007) which works fine:
=IF(B47="Haywood",R47*0.1,IF(F47="Subcontractor",R47*0.1,IF(B47="City General",IF(R47<=25000,R47*0.05,IF(R47<=100000,R47*1.03+1250,R47*0.01+4250)),0)))
However I need to add another IF into the equation. IF F47="Project Co",R47*0
Is this possible or have I exceeded the Nested IF limit? I can't seem to get it to work and it says I have too many arguments.
In which case, is there a way around this, or another formula (without using VBA)?
Best regards
Nick
I have the formula below in my spreadsheet (excel 2007) which works fine:
=IF(B47="Haywood",R47*0.1,IF(F47="Subcontractor",R47*0.1,IF(B47="City General",IF(R47<=25000,R47*0.05,IF(R47<=100000,R47*1.03+1250,R47*0.01+4250)),0)))
However I need to add another IF into the equation. IF F47="Project Co",R47*0
Is this possible or have I exceeded the Nested IF limit? I can't seem to get it to work and it says I have too many arguments.
In which case, is there a way around this, or another formula (without using VBA)?
Best regards
Nick