Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
= IF blank
If I have B2 referring to A1 and A1 has no data, how do I write this so that
B2 is blank instead of showing a zero? Thanks for the help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
= IF blank
=if(A1=0,"",A1)
or to cover null, =if(OR(A1=0,A1=""),"",A1) "Jim" wrote: If I have B2 referring to A1 and A1 has no data, how do I write this so that B2 is blank instead of showing a zero? Thanks for the help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
= IF blank
"Jim" wrote:
If I have B2 referring to A1 and A1 has no data, how do I write this so that B2 is blank instead of showing a zero? =if(A1="", "", A1) Do not use IF(ISBLANK(A1),"",A1). That works only when A1 is truly empty, i.e. it has no formula and no constant. But as you can with the result in B2, your perception of a cell with "no data" might be misled by a formula that results in the null string. Of course, if you truly want to distinguish between the null string and truly empty -- very rare -- ISBLANK() is indeed the function to use. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
= IF blank
Could be even
=IF(A1,A1,"") If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: If I have B2 referring to A1 and A1 has no data, how do I write this so that B2 is blank instead of showing a zero? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
where can I down Blank Worksheets, blank stmt. of account forms | Excel Discussion (Misc queries) | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions |