If((AND)) Formula

[finlain]

I am looking to add on to a working formula that will see a "Null" value as a "0".
Currently my formula reads
=If((AND(T3>0,T3>=C3)),"Yes","Less")

When C3 is "blank" the result is showing "Less" when it should actually be "Yes".

I tried to use Find&Select, Go to Special to replace "blanks"with "0" and it did not work.

Any ideas?

[dredwolf]

try this:
=IF(AND(T3>0,T3>=VALUE(C3)),"Yes","Less")

Hope this helps

[finlain]

Hi
dredwolf

try this:
=IF(AND(T3>0,T3>=VALUE(C3)),"Yes","Less")

Hope this helps


I tried this and now I get a #Value! if T3 is 0 and C3 is blank....

[Kevin UK]

Hi finlain

How about: =IF(AND(T3>0,T3>=C3),"Yes",IF(T3="","Yes","Less"))

[finlain]

Getting closer! Thank you.
What this formula did is it gave me a "Yes" anytime that the "C" value was blank even when the "T" column showed 0.

[Ace_XL]

maybe..

=IF(OR(C3="",AND(T3>0,T3>=C3)),"Yes","Less")

[finlain]

Thank you as always for the replies. This board is great and a lot of talent out here! I found that my first formula was fine it was a "formatting" issue on the blank cells

Drove me nuts!