Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NULL Cells
Works perfectly - thanks all for the fix...
Much appreciated... UCG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Checking that any cells are null | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions |