| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Most functions do not work and return #Name?
Most functions I enter return a #NAME? error in the field
Example Functions that do NOT work: =QUOTIENT(5, 2) =complex(3,4) =IMAGINARY("3+4i") (None of the engineering functions work) All of the above functions return the error "#NAME?" Example functions that work: =sum =odd =even =concatenate Logical functions all work. I have tried other computers at my company and it works fine. Any ideas? Cheers, James Microsoft Office Excel 2003 (11.6560.6568) SP2 Part of Microsoft Office Standard Edition 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most functions do not work and return #Name?
Go into Excel help, look up the functions QUOTIENT, COMPLEX, and IMAGINARY
and see what it says at the end of the sentence which starts: "If this function is not available, and returns the #NAME? error, ..." If in doubt, it's always worth trying Excel help. -- David Biddulph wrote in message ps.com... Most functions I enter return a #NAME? error in the field Example Functions that do NOT work: =QUOTIENT(5, 2) =complex(3,4) =IMAGINARY("3+4i") (None of the engineering functions work) All of the above functions return the error "#NAME?" Example functions that work: =sum =odd =even =concatenate Logical functions all work. I have tried other computers at my company and it works fine. Any ideas? Cheers, James Microsoft Office Excel 2003 (11.6560.6568) SP2 Part of Microsoft Office Standard Edition 2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most functions do not work and return #Name?
You need to activate couple of add-ins.
Goto Tools--Add-ins -- Click the checkbox for Analysis ToolPak and Analysis ToolPak - VBA and then click OK. You might need Office CD as well, if these features were not installed at the first time. -- Cheers Rodrick "David Biddulph" wrote: Go into Excel help, look up the functions QUOTIENT, COMPLEX, and IMAGINARY and see what it says at the end of the sentence which starts: "If this function is not available, and returns the #NAME? error, ..." If in doubt, it's always worth trying Excel help. -- David Biddulph wrote in message ps.com... Most functions I enter return a #NAME? error in the field Example Functions that do NOT work: =QUOTIENT(5, 2) =complex(3,4) =IMAGINARY("3+4i") (None of the engineering functions work) All of the above functions return the error "#NAME?" Example functions that work: =sum =odd =even =concatenate Logical functions all work. I have tried other computers at my company and it works fine. Any ideas? Cheers, James Microsoft Office Excel 2003 (11.6560.6568) SP2 Part of Microsoft Office Standard Edition 2003 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most functions do not work and return #Name?
I had checked help(f1) numerous times, however, i glanced over the
start and scrolled to the end as this is where troubleshooting section is usually located in manuals. I found the remarks section where it talked about the #VALUE error and because it did not mention #name I looked no further. The second paragraph of the help says "If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in." On Oct 17, 4:42 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Go into Excel help, look up the functions QUOTIENT, COMPLEX, and IMAGINARY and see what it says at the end of the sentence which starts: "If this function is not available, and returns the #NAME? error, ..." If in doubt, it's always worth trying Excel help. -- David Biddulph wrote in message ps.com... Most functions I enter return a #NAME? error in the field Example Functions that do NOT work: =QUOTIENT(5, 2) =complex(3,4) =IMAGINARY("3+4i") (None of the engineering functions work) All of the above functions return the error "#NAME?" Example functions that work: =sum =odd =even =concatenate Logical functions all work. I have tried other computers at my company and it works fine. Any ideas? Cheers, James Microsoft Office Excel 2003 (11.6560.6568) SP2 Part of Microsoft Office Standard Edition 2003- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Most functions do not work and return #Name?
Cheers mate.
On Oct 17, 7:00 pm, Rodrick wrote: You need to activate couple of add-ins. Goto Tools--Add-ins -- Click the checkbox for Analysis ToolPak and Analysis ToolPak - VBA and then click OK. You might need Office CD as well, if these features were not installed at the first time. -- Cheers Rodrick "David Biddulph" wrote: Go into Excel help, look up the functions QUOTIENT, COMPLEX, and IMAGINARY and see what it says at the end of the sentence which starts: "If this function is not available, and returns the #NAME? error, ..." If in doubt, it's always worth trying Excel help. -- David Biddulph wrote in message ups.com... Most functions I enter return a #NAME? error in the field Example Functions that do NOT work: =QUOTIENT(5, 2) =complex(3,4) =IMAGINARY("3+4i") (None of the engineering functions work) All of the above functions return the error "#NAME?" Example functions that work: =sum =odd =even =concatenate Logical functions all work. I have tried other computers at my company and it works fine. Any ideas? Cheers, James Microsoft Office Excel 2003 (11.6560.6568) SP2 Part of Microsoft Office Standard Edition 2003- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return value from functions in other sheets? | Excel Worksheet Functions | |||
| All arithmetic functions return Zero as result | Setting up and Configuration of Excel | |||
| Return key doesn't work in excel. | Excel Discussion (Misc queries) | |||
| using muliple functions to return one result | Excel Worksheet Functions | |||
| Return only work days | Excel Discussion (Misc queries) | |||
Linear Mode
