i need some help as i have too many if functions with the formula i need to write. this is what the complete formula should be:
=IF(AB2="A*",0,IF(AB2="A",1,IF(AB2="B",2,IF(AB2="C",3,IF(AB2="D",4,IF(AB2="E",5,IF(AB2="F",6,IF(AB2="G",7,IF(AB2="U",8,"NA")))))))
it will cope until the last if but then it says theres to many i know abit about naming formulas but cant get that to work, and dumbed down help would be much appreciated
thanks
Samantha
=IF(AB2="A*",0,IF(AB2="A",1,IF(AB2="B",2,IF(AB2="C",3,IF(AB2="D",4,IF(AB2="E",5,IF(AB2="F",6,IF(AB2="G",7,IF(AB2="U",8,"NA")))))))
it will cope until the last if but then it says theres to many i know abit about naming formulas but cant get that to work, and dumbed down help would be much appreciated
thanks
Samantha