NULL Cells
Replace the returned value of 0 with the empty string, "".
=IF(ISNUMBER(C2),"",IF(N2=("SOMETEXT"),"",((K2-J2)*4)))
A formula only leaves output to the cell it is entered in. It cannot
change any other cell.
HTH
Kostis Vezerides
UnderCoverGuy wrote:
Using the formula:
=IF(ISNUMBER(C2),0,IF(N2=("SOMETEXT"),0,((K2-J2)*4)))
returns a 0 in the cell if C2 is a number. Is there a way for me to have it
either delete the value of the cell or make the cell null? I don't want
anything to display if C2 is a number.
Any thoughts?
Thanks in advance,
UCG
|