#### nickwood1066

##### Board Regular

- Joined
- Aug 21, 2009

- Messages
- 55

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