IF function with Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?


TSG said:
I have a simple if function which looks like this:
Click to expand...
=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?
 
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?
 
Dave R. said:
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?
Click to expand...

Works on mine - try re-typing it.
 
Back
Top