Hi All,

Im trying to categorise clients by the amount of revenue they generate. Ive created an IF formula to do this but it doesnt seem to be working. So far I have the IF formula below:

=IF(T4>20000,"Gold",IF(T4>15000,"Silver",IF(T4>10000,"Green",IF(T4>5000,"A",IF(T4>2500,"B",IF(T4>1500,"C","D"))))))
Which refers to Cell T4 where the amounts are, the amounts are worked out using the formula below which is in T4:

=IF(SUM(AS4:BD4)>0,SUM(AS4:BD4),"")
The problem is im getting a result of 'Gold' for the clients that have 0 revenue (which means the cell would be blank). How can this be as the IF formula should only return 'Gold' if the amount is over 20000..

Any ideas?

Thanks