| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom format that shows blank cell if another cell is empty
I have a formula in A1, just referrencing to B1 (=B1)
I need to setup following custom format to A1: If B1 is blank, show blank in A1 If B1 is is 0, show 0 in A1. If B1 is positive, show the positive in A1. I have a problem, that blank and zero behave same, so when B1 is blank, I get always 0 instead of blank. Is it possible using customer format, not formula (if-then)? Thank you Zdenek Moravec |
|
#2
|
|||
|
|||
|
Formula will do it
=IF(B1="","",IF(B1=0,0,IF(B10,"+ve",""))) -- HTH RP (remove nothere from the email address if mailing direct) "Zdenek Moravec" wrote in message om... I have a formula in A1, just referrencing to B1 (=B1) I need to setup following custom format to A1: If B1 is blank, show blank in A1 If B1 is is 0, show 0 in A1. If B1 is positive, show the positive in A1. I have a problem, that blank and zero behave same, so when B1 is blank, I get always 0 instead of blank. Is it possible using customer format, not formula (if-then)? Thank you Zdenek Moravec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
| Make a cell blank? | Excel Worksheet Functions | |||
| SUM until blank cell | Excel Worksheet Functions | |||
Linear Mode
