Excel IF Question 1

[cdove]

Is it possible to use an IF statement to have a value of 1 if a cell has text in and 0 if no text exists?

eg IF (Cell contains text) = "1", "0

 

[tviman]

Absolutely! =if(a1>0,a1+b1,"")

There's always a better way. The fun is trying to find it!

 

[SkipVought]

Hi,
[tt]
=IF(ISBLANK(A1),1,0)
[/tt]
and...

why do you want the CHARACTERS "0" & "1" rather than the NUMBERS 0 & 1???



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

oops
[tt]
=IF(ISBLANK(A1),0,1)
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ajakeway]

Interestingly, this also works.

=1-ISBLANK(B1)

Perhaps not as readable, but I find I can use the Boolean True / False (treated as 1/0) in all sorts of places.

 

[KenWright]

And if you really want to cut it down, and assuming the choice is text or Not text as stated, then

=--ISTEXT(B1)

will also do the job, though not as generic as the others, which also cater for numerics, which this won't.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[cdove]

Thanks Everyone. I eventually went for SkipVought..

 

[Dreamboat]

I went for SkipVought once too, and then find out he was married!

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[KenWright]

LOL

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[cranebill]

<=== Not married lol

Bill

 

[SkipVought]

Geez,

I was out cutting the lawn and felt these STRANGE VIBES!!!

Little did I know I'd become the HOTTIE of Tek-Tips at the late age of 62!

What will my WIFE say???

;-)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884