How do I get more than 7 functions in EXcel?

G

Guest

I need to enter the following formula in Excel
<=IF(J2>=1056,"SM|13",IF(J2>=880,"SM|12",IF(J2>=735,"SM|11",IF(J2>=614,"MM|10",IF(J2>=519,"MM|9",IF(J2>=439,"G1|8",IF(J2>=371,"G1|7",IF(J2>=269,"G1|6",IF(J2>=260,"G1|5",IF(J2>=187,"G2|4",IF(J2>=141,"G3|3",IF(J2>=116,"G4|2",IF(J2>=0,"G4|1")))))))))))))>
but it wont allow me due to there being more than 7 functions within a
function but I need it, is there a way around it? let me know Thanx
 
A

Arvi Laanemets

Hi

=CHOOSE(MATCH(J2,{0,116,141,187,260,269,371,439,519,614,735,880,1056},1),"SM
|13","SM|12","SM|11","MM|10","MM|9","G1|8","G1|7","G1|6","G1|5","G2|4","G3|3
","G4|2","G4|1")

(It's possible to have up to 24 different choices that way. When there is
more, then you have to use VLOOKUP)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More Math than Excel 5
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS 2
Still using Excel 2000. How to nest more than 7 in IF formula 1
How do I enter a function that has more than 7 nested functions 6
How can I nest more than seven functions in MS Excel? 3
How can I create a formula out of more than 7 functions in excel? 3
How do I put in more than 7 validations in IF FORMALA in EXCEL 3
How can use IF function more than 7 times in a cell 4

Top