Showing Error when going to pass a function like this
 

=IF(C2=1,"Ten",IF(C2=2,"Twenty",IF(C2=3,"Thirty",I F(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
--
B.Mohanty

Showing Error when going to pass a function like this
 

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","Thi rty","Forty","Fifty","Sixty","Seventy","Eight","Ni ne"),0)

Biff

"Brahmananda Mohanty" wrote
in message ...
=IF(C2=1,"Ten",IF(C2=2,"Twenty",IF(C2=3,"Thirty",I F(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
--
B.Mohanty