Struggling with blank cells

[Red Bull]

Group,

I have a formula in A2 that I am struggling with to show correctly: =IF(A1>=0.5,B1,IF(A1="","",IF(A1<.5,B2)))

What I am trying to do is look in A1 for a value. If the value is greater than or equal to .5, give me B1 and if it's less than .5, give me B2.
However the problem I'm having is if F1 is blank, I would like A2 to be blank but it's not working.

A1 has a formula in it that makes it display as ""

Thanks,

 

[Jonmo1]

Test for the blank first, then the numeric tests..

=IF(A1="","",IF(A1>=0.5,B1,IF(A1<0.5,B2)))

The way you had it, if A1 is a formula returning "", then A1>=0.5 is TRUE
YES, > and < operators consider TEXT strings to be greater than Numbers ("" is a text string, not a blank).

 

[Red Bull]

Test for the blank first, then the numeric tests..

=IF(A1="","",IF(A1>=0.5,B1,IF(A1<0.5,B2)))

The way you had it, if A1 is a formula returning "", then A1>=0.5 is TRUE
YES, > and < operators consider TEXT strings to be greater than Numbers ("" is a text string, not a blank).

You nailed it Jonmo1! Thanks a million!!!

 

[Jonmo1]

You're welcome