Multiple If Query

[Excel_77]

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?

 

[Gerald Higgins]

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]

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.