If function - Add if its blank, to return blank

N

Natalie

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!
 
R

Rick Rothstein \(MVP - VB\)

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
 

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

Newbie Help - IF Yes No Function 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Excel - Wich Function should I use? 1
Publisher is filling blank lines with data 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Hide columns based on row values 2
If Not blank - Formula for two cells 0
VLOOKUP text vs number issues returning value 13

Top