If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to tell the difference between a zero and a blank cell value
Well the title says it all folks. I have a worksheet that
runs a formula that needs to be able to tell the difference betwwen a blank cell and a cell value that contains a zero. Presently the formula that displays the blank cells as a zero as well as cells that contain zeros. I need to find a solution that is able to differentiate between the two. Thanks in advance .... Slider |
#2
|
|||
|
|||
How to tell the difference between a zero and a blank cell value
Hi
you may post your formula: To identify a blank cell use =IF(ISBLANK(A1),"something","something else") For checking for zeros use =IF(A1=0,"something","something else") For blank cells as well as the formula result "" use =IF(A1="","something","something else") -- Regards Frank Kabel Frankfurt, Germany "Slider" schrieb im Newsbeitrag ... Well the title says it all folks. I have a worksheet that runs a formula that needs to be able to tell the difference betwwen a blank cell and a cell value that contains a zero. Presently the formula that displays the blank cells as a zero as well as cells that contain zeros. I need to find a solution that is able to differentiate between the two. Thanks in advance .... Slider |
#3
|
|||
|
|||
How to tell the difference between a zero and a blank cell value
Hi Slider!
Try the following base: =IF(ISBLANK(C18)=TRUE,"Blank",IF(C18="","Empty String",IF(C18=0,"Zero","May be format hidden"))) If the only possibilities are Blank and 0 the formula can be edited to =IF(ISBLANK(C18),"Blank","Zero") -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Slider" wrote in message ... Well the title says it all folks. I have a worksheet that runs a formula that needs to be able to tell the difference betwwen a blank cell and a cell value that contains a zero. Presently the formula that displays the blank cells as a zero as well as cells that contain zeros. I need to find a solution that is able to differentiate between the two. Thanks in advance .... Slider |
Thread Tools | |
Display Modes | |
|
|