Showing Error when going to pass a function like this

  • Thread starter Brahmananda Mohanty
  • Start date
B

Brahmananda Mohanty

=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
 
T

T. Valko

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
 
Top