Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|