NULL Cells
 

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

NULL Cells
 

Change
=IF(ISNUMBER(C2),0,IF(N2=("SOMETEXT"),0,((K2-J2)*4)))
to
=IF(ISNUMBER(C2),"",IF(N2=("SOMETEXT"),0,((K2-J2)*4)))
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"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

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

NULL Cells
 

=IF(ISNUMBER(C2),"",IF(N2=("SOMETEXT"),0,((K2-J2)*4)))
but be aware that there are subtle differences in Excel between a blank cell
and an empty string.
--
David Biddulph

"UnderCoverGuy" wrote in message
...
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

NULL Cells
 

Works perfectly - thanks all for the fix...

Much appreciated...


UCG