# Formula that References a data validation list

#### NYEXCEL1

##### Board Regular
I have a text list dropbox with one blank cell included in cell A1. In B1 I have a formula that says =IF(A1<>0,1+1,""). No matter if the blank or text is chosen B1 shows as "2".

I have also tried with ISBLANK and ISTEXT but get the same results. I should be getting a blank cell in B1 to work correctly.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
NYEXCEL1,

Try =IF(A1<>"",1+1,"")

Hope that helps.

thanks snakehips but I am getting the same wrong answer. In a regular blank cell (as if you were opening a new workbook), your formula and mine work. But with a blank cell in data validation dropdown list it is giving me the true value. When I use ISBLANK it says "True" so I am confused why excel is reading the cell different through data validation.

In the example below, E is a dv list for A1:A3 with formulas in E and F is a dv list for A4:A6 with just text.

There are both our fomulas in B1:B6
A1:A6 has been populated from the dv drop list.
The only one that appears, to me, to give your 'bad' result of 2 is your formula in B1.

Excel 2007
ABCDEF
12AA
2C2BB
3
4 CC
5 DD
6B2
Sheet3
Cell Formulas
RangeFormula
E1=IF(F1="n","",F1)
B1=IF(A1<>0,1+1,"")
B2=IF(A2<>"",1+1,"")
B3=IF(A3<>"",1+1,"")
B4=IF(A4<>"",1+1,"")
B5=IF(A5<>0,1+1,"")
B6=IF(A6<>0,1+1,"")

That's why, for me, IF(A1<>"",1+1,"") appeared ok?

Replies
9
Views
282
Replies
3
Views
394
Replies
1
Views
227
Replies
2
Views
187
Replies
2
Views
232

1,196,409
Messages
6,015,103
Members
441,870
Latest member
kojack

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