Can anyone tell me what is wrong with the following formula? =IF(AS26<0,"G",IF(AS26>0<>AS26<5,"Y",IF(AS26>6,"R"))). The target cell is AV14. I want the target cell to equal one of three values (G,Y,R) given that the value of AS26 meets the following requirements: If AS26 is <0 = "G", If AS26 is >0 but <5 = "Y" and If AS26 is >6 = "R"... HELP!