# If Then Statemets excel 2010

#### carlpopp

##### New Member
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.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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

Hi Carl,

Try

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

AWESOME!

Thanks everyone! Mr.Excel site rocks!

We are glad to have helped and thanks for the feedback

Replies
6
Views
156
Replies
14
Views
372
Replies
1
Views
374
Replies
11
Views
367
Replies
1
Views
248

1,203,236
Messages
6,054,298
Members
444,715
Latest member
GlitchHawk

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