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
Bookmarks