Using min and max function XL2002
 

I need to find the min and max of four values (c38;c39;g38;g39) that is
greater than zero, but not matter what function I use I either get an answer
of zero or and error. Can anyone help me?

For the maximum...

=MAX(C38,C39,G38,G39)

or

=MAX(C38:C39,G38:G39)

For the maximum, greater than zero...

=MAX(IF(N(INDIRECT({"C38","C39","G38","G39"}))0,N (INDIRECT({"C38","C39",
"G38","G39"}))))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. For the minimum,
change MAX to MIN.

Hope this helps!

In article ,
"Extremely Aggravated" <Extremely
wrote:

I need to find the min and max of four values (c38;c39;g38;g39) that is
greater than zero, but not matter what function I use I either get an answer
of zero or and error. Can anyone help me?