Formula not working in excel

J

James

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
 
G

Gary Smith

Most likely some of the values have been entered as text rather than as
numbers. To fix this, enter a zero in any hand cell, then right-click the
cell and click Copy. Now select cells A1 through A162, right-click, click
Paste Special, click the Add button under Operation, and click OK. The
text values will be converted to numbers and your function should work as
intended.


James said:
Hello and thanks in advance.....
Click to expand...
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;

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.
Click to expand...
If I over type the data in all the cells the formula works however I cannot
tell the user to retype thousands of enteries.
Click to expand...
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).
Click to expand...
Any ideas why this happened but more importantly is there a easy fix to
correct this?
Click to expand...
 

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

Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
Consolidation Table from Different Excel Tabs with Different Format 1
Excel formula not working 3
Excel does not accept text format! 0
Need Help with a VBA subroutine 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
External cell reference between two excel worksheets both in One Drive 0

Top