Blank entry in an IF statement returns FALSE. I want it to be blank

  • Thread starter Thread starter wasted wanderer
  • Start date Start date
W

wasted wanderer

When I have no entry in a cell within an IF statement it returns as
"FALSE". I want it to be blank and have no value.

If I use if(ai="","") I still get FALSE unless the entry is done via
the spacebar and then I get a blank cell. How do I get a blank cell
when no entry is made?

Thank you,

Rudy
 
You need to give the formula a FALSE option. Assuming that you want the
value in A1 use:

=IF(A1="","",A1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
When I have no entry in a cell within an IF statement it returns as
"FALSE". I want it to be blank and have no value.

If I use if(ai="","") I still get FALSE unless the entry is done via
the spacebar and then I get a blank cell. How do I get a blank cell
when no entry is made?

Thank you,

Rudy
Click to expand...

you have too few arguements. you are missing the 2nd ,
try

=IF(A1="","","")
 
Back
Top