Value Error (nested IF)

Hi guys,

Just wondered why I'm getting a value error in M9.

Any questions feel free to ask

Thanks

Hi Median,

I think you have too many arguments in your first IF statement. Try this instead.

=IF(L9<>"",((K9/H9)*100-100),IF(H9=K9,(((H9-0.02)/H9)*100-100),0))

Using the Formula Tab -> Evaluation tool and stepping through your formula gives "=0,0" which Excel doesn't know how to deal with, so you get a #Value.