Using min and max function XL2002

  • Thread starter Extremely Aggravated
  • Start date
E

Extremely Aggravated

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?
 
D

Domenic

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!

"Extremely Aggravated" <Extremely
 
Top