NULL Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UnderCoverGuy - 31 Oct 2006 18:31 GMT

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

Reply to this Message

Gary Brown - 31 Oct 2006 19:02 GMT

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

Signature

HTH,
Gary Brown
gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

> Using the formula:
>
[quoted text clipped - 8 lines]
> Thanks in advance,
> UCG

Reply to this Message

vezerid - 31 Oct 2006 19:05 GMT

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

> Using the formula:
>
[quoted text clipped - 8 lines]
> Thanks in advance,
> UCG

Reply to this Message

David Biddulph - 31 Oct 2006 19:10 GMT

=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.

Signature

David Biddulph

> Using the formula:
>
[quoted text clipped - 9 lines]
> Thanks in advance,
> UCG

Reply to this Message

UnderCoverGuy - 31 Oct 2006 20:33 GMT

Works perfectly - thanks all for the fix...

Much appreciated...

UCG

Reply to this Message