Showing Error when going to pass a function like this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(C2=1,"Ten",IF(C2=2,"Twenty",IF(C2=3,"Thirty",IF(C2=4,"Forty",IF(C2=5,"Fifty",IF(C2=6,"Sixty",IF(C2=7,"Seventy",IF(C2=8,"Eight",if(c2=9,"Nine",0))))))))

why it is not working , but i receive a error message
Please guide me
 
What version of Excel are you using? Your formula will work in Excel 2007
only. If you have another version then you've exceded the maximum number of
nested function levels allowed which is 7. You have 8.

There are a few ways you could do this. Here's one:

=IF(AND(C2>=1,C2<=9),CHOOSE(C2,"Ten","Twenty","Thirty","Forty","Fifty","Sixty","Seventy","Eight","Nine"),0)

Biff
 
You must log in or register to reply here.

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

Logical if more than 7 4
How do I replace data in a cell in Excel? 1
How to find best and worst grade? 5
Ratio - How To Create Your Own Function/Formula 2
Array Function? 4
How to divide numbers in Excel? 0
If statement when two cells are the same 2
adding values if the same - SUMIF in range of cells? 4

Back
Top