Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with IF function
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. "rmo5354 " wrote: I need help writing an IF expression: IF("reference cell is empty", leave blank, otherwise statement) thanx --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
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. "ElsiePOA " wrote: =IF(A1="","",Statement) --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |