Adjusting an If Formula (Separate Query)

[Excel_77]

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", ""))

Thanks in advance

 

[BarryL]

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", "")))

 

[Excel_77]

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.

 

[BarryL]

Thanks Barry - that works.

Any time.

 

[Excel_77]

Any time.

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