Problem with multiple IF statements, sometimes returns "FALSE"

[olivierv]

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?

 

[gaz_chops]

Not sure but wouldn't AND be better

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

 

[steve the fish]

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]

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