| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement - blank cell
Cell B8 may contain one of the following: P, H, S, V, O
Formula needed: If B8 is not blank, then B8, else "" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement - blank cell
=IF(B8="","",B8)
or =IF(ISBLANK(B8),"",B8) Please note that if cell B8 itself has a formula that returns "", then it is not blank and these will not work. Try =IF(LEN(B8)<1,"",B8) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "--Viewpoint" wrote in message ... Cell B8 may contain one of the following: P, H, S, V, O Formula needed: If B8 is not blank, then B8, else "" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement - blank cell
=IF(B8="","",B8)
-- Gary''s Student - gsnu200908 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If, then statement with the condition a blank cell | Excel Worksheet Functions | |||
| returning blank cell in an if statement | Excel Worksheet Functions | |||
| if statement when cell is blank | Excel Worksheet Functions | |||
| keep cell blank if IF statement is False | New Users to Excel | |||
| keep cell blank when false in IF statement | Excel Discussion (Misc queries) | |||
Linear Mode
