nested if
Your first 2 IF statements, D10<K10 and D10=K10, well D10 will always meet
one of those 2 criteria, so will never worry about D10=0. You need to
evaluate that first:
=IF(D10=0,0,IF(D10<K10,L10,F10))
Hope this helps.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.
"ACarella" wrote:
I have the following if statement.
The third IF statement is not working.
Please help.
Thank you.
Arlene
=IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00)))
the 3rd IF statement can also be interpreted as IF(B10=' ',D10)))
If cell B10 is blank, then return the value in D10
|