# IF AND OR statement

• Hi,

I have a small table that looks as followed;

[ATTACH=CONFIG]71866[/ATTACH]

I am trying to have the invest or do not invest auto populate, the factors are; B > 5% and C > 8% or D > 5

I am using the following formula;

=IF(AND(OR(B7>=5%,C7>=8%),OR(D7>=5)),"Invest","Do not invest")

It works for some of the rows but not all of them?

For example rows 7 and 9 should be "invest" as they meet the above criteria..

## Images

• Re: IF AND OR statement

Hi 3ball,

Put this formula into cell E4...

=IF(AND(B4>=5%,C4>=8%,D4>=5),"Invest","Do not invest")

...and fill down to cell E9. Note none of the six portfolios meet all three criteria you have listed for an "invest" option to be returned.

HTH

Robert

• Re: IF AND OR statement

Thanks,

Sorry if I didn't make it clear, however, I need to use the AND OR statement because either B > 5% AND C > 8% OR D > 5.

• Re: IF AND OR statement

=IF(OR(AND(D9>=5),AND(B9>=5%,C9>=8%)),"Invest","Do not invest")

Think I got it.. I suppose the AND needs to be nested in the OR not vica versa?

• Re: IF AND OR statement

So just to get the logic - if Col. E is greater then 5 than "invest", else if both percentages in Col. B and Col. C are equal to or greater than 5% and 8% respectfully then "invest" else "Do not invest"?