# Multiple If Query

#### Excel_77

##### Active Member
Hi All,

I want to carry out a query that does the below:

1. If A1 = Yes return - "Ignore".

2. If A1 = No and B1 = "GBP", I want to then check if R1 is over 1000, if it is return "review" otherwise I want the calculation O1-500 performed.

3. If A1 = No and B1 = "EUR", I want to then check if R1 is over 1500, if it is return "review" otherwise I want the calculation O1-600 performed.

4. Finally If A1 = No and B1 = anything other than GBP or EUR I want to then check if R1 is over 1500, if it is return "review" otherwise I want the calculation O1-650 performed.

Can anyone help?

Last edited:

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Gerald Higgins

##### Well-known Member
Perhaps . . .

=if(A1="Yes","Ignore",if(B1="GBP",if(R1>1000,"review",o1-500),if(B1="EUR",if(R1>1500,"review",o1-600),if(R1>1500,"review",o1-650))))

Assumes A1 can only be "Yes" or "No"

#### Excel_77

##### Active Member
Perhaps . . .

=if(A1="Yes","Ignore",if(B1="GBP",if(R1>1000,"review",o1-500),if(B1="EUR",if(R1>1500,"review",o1-600),if(R1>1500,"review",o1-650))))

Assumes A1 can only be "Yes" or "No"

Thanks, that's brilliant.

Replies
5
Views
250
Replies
16
Views
1K
Replies
2
Views
995
Replies
1
Views
441
Replies
2
Views
554

1,191,537
Messages
5,987,166
Members
440,083
Latest member
Bluepanther

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