# Problem with multiple IF statements, sometimes returns "FALSE"

#### olivierv

##### New Member
Hi guys,

I got the following problem. I have a dataset that for which I want to allocte a "1" or a "0" for specific combinations of IF statements.

I'm using the following formula: =IF(ISTEXT(P10),"",IF(P10>25%,IF(Q10>10%,IF(R10>5%,1,0))))

However, in some cases it returns "FALSE" instead of a "1" or a "0". I need to code it like this as I want to do a panel regression. Can anyone tell me what I'm doing wrong?

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### gaz_chops

##### Well-known Member
Not sure but wouldn't AND be better

=IF(ISTEXT(P10),"",IF(AND(P10>25%,Q10>10%,R10>5%),1,0))

#### steve the fish

##### Well-known Member
In your formula your 2nd and 3rd IFs have no false statement. Go to the formula bar. Click the 2nd IF and press the fx button. You will see the FALSE box is empty.

#### olivierv

##### New Member
@steve the fish, thanks. Just being sleepy on a monday morning, thank you!

Replies
7
Views
281
Replies
3
Views
228
Replies
3
Views
172
Replies
2
Views
321
Replies
3
Views
241

1,195,849
Messages
6,011,955
Members
441,657
Latest member
Diupsy

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