NULL Cells

U

UnderCoverGuy

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
 
G

Gary Brown

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
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
V

vezerid

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using IF and VLOOKUP for range of cells 5
Would like to input 3 letters into a cell, each having a different numerical value 5
Excel Formula question 0
Help Writing a SUM Formula 5
Need Formula to "Adjust" to New Column Assignment 3
Link cells with text not numbers 4
combining multiple columns using ", " seperations.. 4
If a Row is blank 13

Top