View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] spam.away.121@gmail.com is offline
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