=IF(AND(D10<K10,D10<0),L10,0)

ACarella wrote:
Hi Bob:
This works and enters the value into M10.
IF(AND(D10<K10,D10<0),L10)
However, if the statement is false it returns
#VALUE!
is there a way to make the statment return 0 if false so that the I can
subtotal on the column?
Thank you.

"Bob Phillips" wrote:


M10: =IF(AND(D10<K10,D10<0),L10,"")

and use that same formula in conditional formatting for L10

--
__________________________________
HTH

Bob

"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