|
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 |
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 |
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 |
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 - |
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 - |
| All times are GMT +1. The time now is 06:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com