| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I indicate a empty or blank cell in an IF function?
I am trying to do a simple IF function but don't know how to indicate if a
cell is empty or blank then I want a certain text value returned. What I am trying is: =IF('Sheet 1'!A15=IS NULL,"NO","YES") What I want is if the cell indicated on an other sheet is empty or blank then the word NO to appear in the formula cell and if it does have text then YES to appear. How can I do this? Hope I made myself clear enough. I couldn't figure out how to ask help the right way to get the correct answer. Thanks for all of your help! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I indicate a empty or blank cell in an IF function?
Never Mind. I seem to have gotten it to work using:
=IF('Sheet 1'!A15="","NO","YES") Thanks again! "Formula Dummie" wrote: I am trying to do a simple IF function but don't know how to indicate if a cell is empty or blank then I want a certain text value returned. What I am trying is: =IF('Sheet 1'!A15=IS NULL,"NO","YES") What I want is if the cell indicated on an other sheet is empty or blank then the word NO to appear in the formula cell and if it does have text then YES to appear. How can I do this? Hope I made myself clear enough. I couldn't figure out how to ask help the right way to get the correct answer. Thanks for all of your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
| Return an empty or blank cell value? | Excel Worksheet Functions | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
Hybrid Mode
