Re: Problem with IF(AND formula

Brilliant. I am starting to see the light. I tried to nest formulas but I can see that it is better to start from the lowest award and work up so to speak.

Unfortunately I made a small error in the first line of the criteria in my my post. It should have read:

If B2 is blank: No award (Column B contains the client name If it is blank, I need to return a blank field - although "No Award" would be ok.)

Bronze: C2>=1000

Silver: C2>=3000,D2>=25,E2>=10

Gold: C2>=6000,D2>=50,E2>=20

Platinum: C2>=10000,D2>=75,E2>=25

Does this look ok? It seems to work.

=IF(B2="","",IF(AND(C2>=10000,D2>=75,E2>=25),"Platinum",IF(AND(C2>=6000,D2>=50,E2>=20),"Gold",IF(AND(C2>=3000,D2>=25,E2>=10),"Silver",IF(C2>=1000,"Bronze","No Award")))))

Thanks to you both for your help.

Simon