Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If A1 is zero, A2 is blank
I am trying to make an adjacent cell blank if the related cell is zero. I
have tried conditional formatting and IF formatting, but I still can't get it to work. Can someone tell me how to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If A1 is zero, A2 is blank
- if blank means EMPTY then it can't be achieved by formulas as it literally means EMPTY - no constants, no formulas (you'll need
macros for that) - if blank means STRING OF ZERO LENGTH ("") then you can try the following formula in [A2]: =IF(A1=0,"",MyAlternative) the string of 0 length looks like blank, but technically is not blank and behaves differently in most situations (not in all though). -- KL [MVP - Microsoft Excel] RU: http://www.mvps.ru/Program/Default.aspx ES: http://mvp.support.microsoft.com/?LN=es-es EN: http://mvp.support.microsoft.com/?LN=en-us Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36 "woitena1" wrote in message ... I am trying to make an adjacent cell blank if the related cell is zero. I have tried conditional formatting and IF formatting, but I still can't get it to work. Can someone tell me how to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If A1 is zero, A2 is blank
KL wrote:
- if blank means EMPTY then it can't be achieved by formulas as it literally means EMPTY - no constants, no formulas (you'll need macros for that) - if blank means STRING OF ZERO LENGTH ("") then you can try the following formula in [A2]: =IF(A1=0,"",MyAlternative) the string of 0 length looks like blank, but technically is not blank and behaves differently in most situations (not in all though). Even a vacuum takes up space, no? Beege |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If A1 is zero, A2 is blank
A similar problem was posted at ...excel.misc
on Mar 1, "How to find...." http://preview.tinyurl.com/2uj8pk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting:highlight row based on blank or non-blank c | 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 | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) |