oh, is there a way to rewrite the formula to return the value if any of the
three IF statements are reached?

"Bob I" wrote:

No you don't seem to understand, ONE OF THE FIRST TWO IF's ARE ALWAYS
TRUE! The third IF will NEVER be reached to be acted upon.

ACarella wrote:

Thank you both for your help.
However, one of my If statements was incorrect.
This is what it should be and I cannot get the third IF statement to
function properly
=IF(D10<K10,L10,IF(D10=K10,F10,IF(B10<C10,D10)))

The 3rd If Statement is the issue. No matter what I do, it doesn't work.
B10 can be blank, so I tried IF B10=' ', D10 or IF B10=0, D10, or IF B10 is
blank, 0
I just can't get it to work. Then it would be the same if this condition
was true then highlight and bold L10
Please help, thank you.

"Don Guillett" wrote:


Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...

Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene