LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
James
 
Posts: n/a
Default Excel formula not working

Hello and thanks in advance.....

I have a user who has crated a spreadsheet & the formula has been entered
correctly but is not showing the true results.
The formula is;

=max(A1:A162)

There are enteries in column A and I am expecting the figure to show as 350.
This is actually showing as 100 - a figure which is also in column A
I have re inserted the formula - this does not work. I have also put the
formula in a completely different cell but again this does not work.

If I over type the data in all the cells the formula works however I cannot
tell the user to retype thousands of enteries.

I have checked the formatting of the spreadsheet, this all looks ok. Also
have checked the tools & options, this is all ok (calculation is set to
automatic).

Any ideas why this happened but more importantly is there a easy fix to
correct this?

Thanks in advance

James

 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Hatchet_Jack Charts and Charting in Excel 1 February 9th 05 10:31 PM
Polynimial trandline formula CLR Charts and Charting in Excel 9 February 7th 05 07:31 PM
Excel: Formula worked last week but now stoppped working. User Excel Worksheet Functions 8 December 10th 04 02:25 PM
Excel formula not working KC Mao Excel Discussion (Misc queries) 2 December 4th 04 01:59 PM


All times are GMT +1. The time now is 12:15 AM.

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"