| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning "no value"
=IF(ISBLANK(A1),IF(ISBLANK(B1),"",C1(likely wron formula);
Don't know if I use a comma or OR, or another formula, but if either A1 or B1 is blank, I want "no value" in C1. If both A1 and B1 have value then it returns the Value in C1. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need correct IF(ISBLANK) formula when referencing whether one of t
=IF(OR(A1="",B1=""),"",C1)
-- Gary''s Student - gsnu200786 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need correct IF(ISBLANK) formula when referencing whether one oftwo cells (OR) is blank, returning "no value"
It would work if you add an OR in the
=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",C1) but it cannot both put a value in C1 (ie, live there) and check the value in C1. On May 15, 12:09 pm, insitedge wrote: =IF(ISBLANK(A1),IF(ISBLANK(B1),"",C1(likely wron formula); Don't know if I use a comma or OR, or another formula, but if either A1 or B1 is blank, I want "no value" in C1. If both A1 and B1 have value then it returns the Value in C1. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need correct IF(ISBLANK) formula when referencing whether one of t
Try this:
=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",C1) Good Luck. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell | Excel Worksheet Functions | |||
| "If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
| Sumproduct formula "breaks" when referencing too many cells, why? | Excel Discussion (Misc queries) | |||
| Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
