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!