MIN formula help

O

Odawg

Hello All,

I want to know what the Max and Min numbers are using the following
formulas. The Max formula seems to work without any problem, however
it's the Min that I have a problem with.

=Max(A2:A10)
=MIN(A2:A10)

If I only have numbers in cells A2:A8 and the lowest number is 150,
then in that cell that I have the following MIN formula in should show
me 150. Instead it's blank because I still have two remaining cells
in my range (A9 and A10).

How can I fix this. Any and all help is greatly appreciated..
 
B

Biff

Hi!

MIN/MAX ignore empty cells.
Instead it's blank because I still have two remaining cells
in my range (A9 and A10).
Click to expand...

Are you sure that A9 and A10 are empty? Could they really contain zeros but
you have the sheet set to not display zero values?

Goto Tools>Options>View>Zero Values

Biff
 

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

Complicated vlookup/min-max query...please help 6
ignore MAX and MIN values in a set to calculate average 5
removing a cell from an array 1
max and min help. 5
Follow-Up (Clarification) to MIN question 4
Min Value 4
min if 6
getting the min and max of a list of numbers 9

Top