# Adjusting an If Formula (Separate Query)

#### Excel_77

##### Active Member
Hi All,

This is a separate query from earlier and involves adjusting a formula I have, any help would be great.

The below formula checks if A1 = either GBP or Euro and if it does it then it checks the value in AG1 and it this is less than 100 the word "check is returned and this is exactly what I want it to do.

The next thing I want done that is not included is A1 to be checked for AUD and if this matches then AG1 needs to be checked and if it is less than 200 the word check needs to be returned.

Finally for all other currencies, I want A1 checked as normal and then the value in Ag1 checked and multiplied by the value in AH1, then if this is less than 200 the word "check" needs to be returned.

=IF(OR(LOWER(A1)="euro",LOWER(A1)="gbp"),IF(AG1<100, "Check", ""), IF(Ag1<200, "Flag", ""))

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
try

=IF(AND(OR(LOWER(A1)="euro",LOWER(A1)="gbp"),AG1<100),"Check",IF(AND(LOWER(A1)="aud",AG1<200),"Check", IF(AG1<200, "Flag", "")))

try

=IF(AND(OR(LOWER(A1)="euro",LOWER(A1)="gbp"),AG1<100),"Check",IF(AND(LOWER(A1)="aud",AG1<200),"Check", IF(AG1<200, "Flag", "")))

try

=IF(AND(OR(LOWER(A1)="euro",LOWER(A1)="gbp"),AG1<100),"Check",IF(AND(LOWER(A1)="aud",AG1<200),"Check", IF(AG1<200, "Flag", "")))

Thanks Barry - that works.

Last edited:
Any time.

I actually have a similar query posted but thought it better to keep separate to save confusion.

Replies
4
Views
50
Replies
8
Views
172
Replies
1
Views
94
Replies
14
Views
356
Replies
13
Views
476

1,203,060
Messages
6,053,303
Members
444,650
Latest member
bookendinSA

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