nagendrababu
New Member
- Joined
- Apr 25, 2012
- Messages
- 4
When I type this "IF Formula", the specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format:
Please help me to solve this problem or is there any other way to get the same results in excel
=IF(AND(E2<50),"0",IF(AND(E2>=50,E2<=54),"5.5",IF(AND(E2>=55,E2<=59),"6.0",IF(AND(E2>=60,E2<=64),"6.5",IF(AND(E2>=65,E2<=69),"7",IF(AND(E2>=70,E2<=74),"7.5",IF(AND(E2>=75,E2<=79),"8.0",IF(AND(E2>=80,E2<=84),"8.5",IF(AND(E2>=85,E2<=89),"9",IF(AND(E2>=90,E2<=94),"9.5",IF(AND(E2>=95,E2<=100),"10")))))))))))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Please help me to solve this problem or is there any other way to get the same results in excel
=IF(AND(E2<50),"0",IF(AND(E2>=50,E2<=54),"5.5",IF(AND(E2>=55,E2<=59),"6.0",IF(AND(E2>=60,E2<=64),"6.5",IF(AND(E2>=65,E2<=69),"7",IF(AND(E2>=70,E2<=74),"7.5",IF(AND(E2>=75,E2<=79),"8.0",IF(AND(E2>=80,E2<=84),"8.5",IF(AND(E2>=85,E2<=89),"9",IF(AND(E2>=90,E2<=94),"9.5",IF(AND(E2>=95,E2<=100),"10")))))))))))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Last edited: