R
rmo5354
I need help writing an IF expression:
IF("reference cell is empty", leave blank, otherwise statement)
than
IF("reference cell is empty", leave blank, otherwise statement)
than
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
ElsiePOA
=IF(A1="","",Statement
B
BenjieLop
=if(Cell Number="","",Statement)
*I need help writing an IF expression:
IF("reference cell is empty", leave blank, otherwise statement)
thanx
G
Geeoff
To indicate a cell is empty, simply use quotes with nothing in between them
(not even a space). For example: =if(A1="","","Not Empty")
In this statement, I have stated that in cell A1, if it is empty it will
show empty, but if there is any value, it will state Not Empty. Let me know
if this helps you out.
(not even a space). For example: =if(A1="","","Not Empty")
In this statement, I have stated that in cell A1, if it is empty it will
show empty, but if there is any value, it will state Not Empty. Let me know
if this helps you out.
B
brodiemac
What if I want to say if any of these cells are not blank then print
"something" Is that possible? I can't seem to get it to work.
"something" Is that possible? I can't seem to get it to work.