If Then Statemets excel 2010

[carlpopp]

Hello Folks. Need help

I am using Excel 2010.

I Need F:23 to either say "yes" or "no"

There are several conditions that need to be met to achieve a "yes"


If B:50>2
If B:51>1
If B:52>0
If F:59>6

If these requirements are met then F:23 should read "yes"
If these requirements are not met then F:23 should read "no"

Can someone please show me how to write this formula out?

Respectfully

Carl Sr.

 

[Jonmo1]

Welcome to the board...
Do you mean if ALL the conditions are met, then Yes.
But if any 1 of the conditions is NOT met, then No ?

=IF(AND(B50>2,B51>1,B52>0,F59>6),"yes","no")

If you meant if any 1 of the conditions are met, then yes
But if none of them are met, then no
Then change the AND to OR

Hope that helps

 

[jeffreybrown]

Hi Carl,

Try

=IF(AND(B50>2,B51>1,B52>0,F59>6),"Yes","No")

 

[carlpopp]

AWESOME!

Thanks everyone! Mr.Excel site rocks!

 

[jeffreybrown]

We are glad to have helped and thanks for the feedback