IF function with Text

[TSG]

I have a simple if function which looks like this: =if(a1="a","good","bad") as long as A1 contains a value (text or numeric) this works fine, but if A1 is empty or contains a formula, the test always comes back as True. Any suggestions?

 

[Arthur]

this worked for me:

=IF(A1="","",IF(A1="a","good","bad"))

a

 

[Dave R.]

It doesn't do that on my computer with the formula you have there. If it's
empty, it's not "a", so you should get "bad". What formula might you have in
A1 that would change your result to true?

I have a simple if function which looks like this:

=if(a1="a","good","bad") as long as A1 contains a value (text or numeric)
this works fine, but if A1 is empty or contains a formula, the test always
comes back as True. Any suggestions?

 

[Mark Graesser]

It shouldn't. I assume from the lower case letters that you typed the formula into your posting. Could you sweep the formula in your formula bar, copy it, and then paste it into your post? Your formula as written here should work fine

Regards
Mark Graesse
(e-mail address removed)

----- TSG wrote: ----

I have a simple if function which looks like this: =if(a1="a","good","bad") as long as A1 contains a value (text or numeric) this works fine, but if A1 is empty or contains a formula, the test always comes back as True. Any suggestions?

 

[Bill P. Sullivan]

It doesn't do that on my computer with the formula you have there. If it's
empty, it's not "a", so you should get "bad". What formula might you have in
A1 that would change your result to true?

Works on mine - try re-typing it.