M
mathel
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
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