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?
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: