Need help with IF function

  • Thread starter Thread starter rmo5354
  • Start date Start date
R

rmo5354

I need help writing an IF expression:
IF("reference cell is empty", leave blank, otherwise statement)

than
 
=if(Cell Number="","",Statement)

*I need help writing an IF expression:
IF("reference cell is empty", leave blank, otherwise statement)

thanx
Click to expand...
 
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.
 
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.
 
You must log in or register to reply here.

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

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Satisfying several criteria 4
Custom Number Format for text 8
Looking for help with If statement 3
Nested IF Function 2
Three possible outputs from an if statement. 3
Help Please with If statement / vlookup 9
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top