Hi

I am looking for a nested if funtion to populate a codition.. my senario is like this.

if cell A is blank or b is >0 then then none other wise next if condtion starts
cell c has 4 condions like Red , green ,blue, yellow.

IF(c2="red",IF(AJ24<=0.1,"GOLD",IF(AJ24<=0.2,"SILVER",IF(AJ24<=0.3,"BRONZE","NONE"))),"NONE"))

for sigle conditon of C is working good for me but i am not able to included rest of the 3 colors. into it.

till the below point is working i want to include rest of the 3 colours into it please help..
=IF(OR(A2="",VALUE(b2)>0),"NONE",IF(c2="red",IF(AJ2<=0.1,"GOLD",IF(AJ2<=0.2,"SILVER",IF(AJ2<=0.3,"BRONZE","NONE"))),"NONE"))

say other colors you can give gree AJ2<=1 for gold 2 for silver and 3 for bronze smothing like that.

Thanks in advance