What's wrong with this formula?

[grrrrr]

What's wrong with this formula:

=IF(L8>0,(IF('Performance tracker'!B37>=(35%*DB!I71),"50.00",(IF('Performance tracker'!B37<=(34.99%*DB!I71),"25.00"),"0"))))

I'm getting a contained an error message

 

[RichardMGreen]

If you're trying to output numbers as the final values, then you don't need quotes around them.
What is the exact error message you're getting?

 

[kpark91]

Try this :

=IF(L8>0,(IF('Performance tracker'!B37>=(35%*DB!I71),"50.00",(IF('Performance tracker'!B37<=(34.99%*DB!I71),"25.00","0")))))

 

[grrrrr]

Great thanks!

Was it just the quotes that needed to come out then or was there another change in there?

 

[RichardMGreen]

Just had another look, try this:-
=IF(L8>0,IF('Performance tracker'!B37>=(35%*DB!I71),50,IF('Performance tracker'!B37<=(34.99%*DB!I71),25.00,0))),0)

 

[kpark91]

I think the innermost if statement had too many arguments.

It'd be best if you use Richard's formula as it's more stable with another 0 outside.

If you want to use those numbers (from the formula) later on, it would be best if you get rid of the quotes because it will recognize them as text if you do not remove the quotes.

 

[JackDanIce]

Compare the number of brackets from the solution to your original posting

 

[grrrrr]

I see - thanks a lot. Both seem to work fine