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