# Struggling with blank cells

#### Red Bull

##### New Member
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,

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Michael M

##### Well-known Member
Is F1 an extra condition to the formula you provided ??

#### Red Bull

##### New Member
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

##### Well-known Member
Maybe this
Code:
``=IF(A1=CHAR(34)&CHAR(34),"",IF(A1>=0.5,B1,B2))``

#### Michael M

##### Well-known Member
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

##### Well-known Member
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

##### Well-known Member
That will cause the same issues as I have mentioned in the previous post.

#### Red Bull

##### New Member
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 "".

Last edited:

#### Red Bull

##### New Member
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

##### New Member
Maybe this
Code:
``=IF(A1=CHAR(34)&CHAR(34),"",IF(A1>=0.5,B1,B2))``

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

Replies
4
Views
312
Replies
5
Views
798
Replies
2
Views
398
Replies
1
Views
292
Replies
6
Views
164

1,195,934
Messages
6,012,385
Members
441,694
Latest member
Elvin A

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back