| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested "If formula" - returns zero when reference cell is empty
In cell A I can have one of three things... a blank cell, a cell value
of zero or a cell value greater than zero. Depending on which value is in cell A1 I want the value in cell B1 to be the following: A1 is greater than zero - B1 should =A1 plus 1 A1 is equal to zero - B1 should = 0 A1 is empty = B1 should be empty Shown below is the nested "if formula' I wrote. The problem is when A1 is empty a zero is displayed in B1. In this senario I want cell B1 to be blank. I know I can suppress zero values from displaying but that affects the whole woksheet and I don't want that. =IF(A10,A1+1,IF(A1=0,"0",IF(A1="",""))) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nested "If formula" - returns zero when reference cell is empty
On Mar 2, 8:49 am, wrote:
In cell A I can have one of three things... a blank cell, a cell value of zero or a cell value greater than zero. Depending on which value is in cell A1 I want the value in cell B1 to be the following: A1 is greater than zero - B1 should =A1 plus 1 A1 is equal to zero - B1 should = 0 A1 is empty = B1 should be empty Shown below is the nested "if formula' I wrote. The problem is when A1 is empty a zero is displayed in B1. In this senario I want cell B1 to be blank. I know I can suppress zero values from displaying but that affects the whole woksheet and I don't want that. =IF(A10,A1+1,IF(A1=0,"0",IF(A1="",""))) =IF(A10,A1+1,IF(A1="","",0)) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nested "If formula" - returns zero when reference cell is empty
=IF(A10,A1+1,IF(A1="","",IF(A1=0,A1,"")))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... In cell A I can have one of three things... a blank cell, a cell value of zero or a cell value greater than zero. Depending on which value is in cell A1 I want the value in cell B1 to be the following: A1 is greater than zero - B1 should =A1 plus 1 A1 is equal to zero - B1 should = 0 A1 is empty = B1 should be empty Shown below is the nested "if formula' I wrote. The problem is when A1 is empty a zero is displayed in B1. In this senario I want cell B1 to be blank. I know I can suppress zero values from displaying but that affects the whole woksheet and I don't want that. =IF(A10,A1+1,IF(A1=0,"0",IF(A1="",""))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leave "formula cell J7" empty until H7 has a date. | Excel Discussion (Misc queries) | |||
| Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell | Excel Worksheet Functions | |||
| a formula that leaves cell "empty"? | Excel Worksheet Functions | |||
| For Each Next returns "Empty" when Data in Cell | Excel Programming | |||
| Have empty cell unless result of formula isn't value of "0"? | Excel Programming | |||
Linear Mode
