Thank you. I tried the formula as suggested: =IF(AND(F46="",D15=""),"",D15)
, however, the result is '0' instread of a blank. Another individual
suggested the following formula which seems to work fine:
=IF(F46<"",IF(D15="","",D15),"")

Thanks again for your help!
--
Linda


"Bob Phillips" wrote:

=IF(AND(F46="",D15=""),"",D15)


--
__________________________________
HTH

Bob

"mathel" wrote in message
...
I am working with Excel 2003. I have a worksheet I am trying to get the
cell
value (in number) based on the condition of 2 cells or leave the cell
blank.

The result I need in Cell D47 is: if Cell F46 and D15 is blank, blank the
cell, but, if D15 is greater than blank, I need the absolute of the number
in
Cell D15. I have tried the following formula, however, I get the result
"False", so I am doing something wrong.

=IF(F46="",IF(D15="","",D15))

Thanks
--
Linda