Ron At present there are no values I show "". The cells are picking up
information when a water quality test is run. So until that test is run the
formula in the cell is as follows
=IF('1st'!$U$900,'1st'!$U$90,"")
scott

"Ron Coderre" wrote:

What are some of the values in the cells refererred to by the MIN and MAX
functions? and what results are the MIN and MAX functions returning?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"scott45" wrote:

Ron

I am sorry I guess I am not following what you want me to try. When I try
the basic max and min function they do not return the max and min number. The
two columns do not have anything to do with each other just two seperate
columns of results.

"Ron Coderre" wrote:

See if I got the basic info right....
Col H: Decimal values (0.01,0.02,0.6, etc).
Col I: Corresponding column of descriptors (<0.05, =0.05)
You want to calculate the minimum and maximum values from Col I.

Could you try something like this?:
H12:H36 contains decimal numbers
I12: =H12 (copy that formula down to H36)
Then, custom format Col B numbers to:
[<0.05]"<.5";[=0.05]"=.5";"=.5"

I37: =MAX(I12:I36)
I387: =MIN(I12:I36)

Am I on the right track?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€ ¢
Regards,
Ron


"scott45" wrote:

I have a coulmn with results in that are in a decimal point example .01, .02.
At the bottom of the coulumn I want to report the max number and the min
number but it does not. Also in one column my results are listed as <0.05
etc. At the bottom of this column I want to report the max and min but it
does not. I believe because they are not whole numbers. Is there a way to
report these numbers. I tried an IF formula where if <0, max(i12:i36) but
that did not work.
thanks is adavance

scott