| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function - Add if its blank, to return blank
Hi,
I have put an If Function on the below formula, but I only want it to appear if the cell has an entry in it. For example CellA CellB Yes =IF(A1="YES","NO","YES") The above works, but it also puts in "Yes" if Cell A is blank, and I want to be blank if CellA is blank. Thanks in advance for any help provided! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function - Add if its blank, to return blank
This should take care of the blank problem...
=IF(A1="","",IF(A1="YES","NO","YES")) However, it is unclear if you want "YES" as the result if anything other than "NO" is entered in A1 (right now, that is what happens). If you want this as a pure Yes/No toggle and blank for anything else... =IF(A1="","",IF(A1="YES","NO",IF(A1="NO","YES","") )) Rick "Natalie" wrote in message ... Hi, I have put an If Function on the below formula, but I only want it to appear if the cell has an entry in it. For example CellA CellB Yes =IF(A1="YES","NO","YES") The above works, but it also puts in "Yes" if Cell A is blank, and I want to be blank if CellA is blank. Thanks in advance for any help provided! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| how do I get the if function to return a blank cell, not 0? | Charts and Charting in Excel | |||
| IF function to return values for cells with blank or - in them | Excel Worksheet Functions | |||
| A function to return the value of a blank cell | Excel Worksheet Functions | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Linear Mode
