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,

 

[Michael M]

Is F1 an extra condition to the formula you provided ??

 

[Red Bull]

Sorry, no. That should read A1.



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 A1 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 ""

 

[Michael M]

Maybe this

=IF(A1=CHAR(34)&CHAR(34),"",IF(A1>=0.5,B1,B2))

 

[Michael M]

ADVERTISEMENT

I guess my next question would be .....why would you have a cell result in A1 as "".
If you wanted to do counting or other queries, that cell would skew the results...?

 

[deletedalien]

you could remove the "" from the formula in cell A1 and then just use cond, formatting to mark the text as white if = to 0... i know its cheap and kinda cheating but it works....

 

[Michael M]

ADVERTISEMENT

That will cause the same issues as I have mentioned in the previous post.

 

[Red Bull]

I guess my next question would be .....why would you have a cell result in A1 as "".

If you wanted to do counting or other queries, that cell would skew the results...?

It is calculated based on a pick-list. However, if the pick-list hasn't been selected yet, I display it as "".

 

[Red Bull]

you could remove the "" from the formula in cell A1 and then just use cond, formatting to mark the text as white if = to 0... i know its cheap and kinda cheating but it works....

I'm ok with cheap and cheating but the problem with this is that sometimes the value in A1 is actually zero and then I would want to return B2 (in regular font).
Nice try though - I like where you're coming from. lol

 

[Red Bull]

Maybe this

=IF(A1=CHAR(34)&CHAR(34),"",IF(A1>=0.5,B1,B2))

No luck with this formula. It still returns B1 if A1 is ""