#NAME?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sent a spread to a co-worker that has some simple calculations. Some of the
calculations are average and standard deviation of value from the same
worksheet, which display properly. However, I am converting some values from
a different worksheet from millimeters to inches and the value displays as
the #NAME? error. Is there a default setting that he needs to change? Also, I
am using xl97 and he is using xl2000.
 
If you're sure the function names are spelled correctly, then it's likely
that the Analysis toolpak add-in is not enabled.

Try this:

Tools>Add Ins
Check: Analysis Toolpak
(If you don't see it listed...you'll need to have it installed)



Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
It worked. Thank you very much.

Ron Coderre said:
If you're sure the function names are spelled correctly, then it's likely
that the Analysis toolpak add-in is not enabled.

Try this:

Tools>Add Ins
Check: Analysis Toolpak
(If you don't see it listed...you'll need to have it installed)



Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Standard Deviations? 3
Metric conversion formula / function 3
slope of data that already contains STDEVs 1
Conditional formatting using part of the cells contents 3
Condtional Formatting and Standard Deviation 2
Standard Deviation 1
Filtered Statistics 2
calc in excel 2

Back
Top