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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wasted wanderer - 05 Apr 2008 19:57 GMT

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

Reply to this Message

Sandy Mann - 05 Apr 2008 20:17 GMT

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

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

Signature

HTH

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

sandymann2@mailinator.com
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.
[quoted text clipped - 6 lines]
>
> Rudy

Reply to this Message

pub - 05 Apr 2008 20:17 GMT

wasted wanderer <seniorbrother@gmail.com> wrote in news:fb799a39-694b-
4402-80bc-5e19f75db9f8@2g2000hsn.googlegroups.com:

> 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.
[quoted text clipped - 6 lines]
>
> Rudy

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

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

Reply to this Message