| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pass variable to NORMINSV function to get only mean value | Excel Worksheet Functions | |||
| How to print when an error message keeps showing? | Excel Discussion (Misc queries) | |||
| Error on second pass of loop. | Excel Discussion (Misc queries) | |||
| error on second pass of loop. | Excel Discussion (Misc queries) | |||
| Calculated Fields showing error results | Excel Discussion (Misc queries) | |||
Linear Mode
