Maybe

=IF(D10="","",IF(D10<L10,L10,IF(D10=K10,F10)))

or

=IF(D10="",0,IF(D10<L10,L10,IF(D10=K10,F10)))

Miek

"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