LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to return value from functions in other sheets? TR Excel Worksheet Functions 3 October 23rd 06 08:25 PM
All arithmetic functions return Zero as result Khoshravan Setting up and Configuration of Excel 9 June 26th 06 03:24 AM
Return key doesn't work in excel. Nicci Excel Discussion (Misc queries) 2 April 28th 06 04:54 PM
using muliple functions to return one result tauwnia Excel Worksheet Functions 1 January 17th 06 08:45 PM
Return only work days mhart210 Excel Discussion (Misc queries) 1 August 18th 05 04:22 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"