If statement - blank cell

V

--Viewpoint

Cell B8 may contain one of the following: P, H, S, V, O

Formula needed: If B8 is not blank, then B8, else ""
 
B

Bernard Liengme

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula returns #N/A 1
LOOOONG if statement out of room, need help to shorten 4
Fixed column- Variable row # 3
Conditional Formating: linking to display another cell 3
SUMIF with criteria "<>" & "=" 4
Two formulas in one cell 3
Skipping a cell and moving on to the next, with no blanks in betwe 8
CountIf previous cell formula 0

Top