Min function as opposed to the MAX function

[Normand]

Hi all,

I am used to the MAX function to find the MAX value with multiple conditions. I use this formula shown in a Chandoo previous post:
{=MAX(IF((Parameter_3=D13)*(Parameter_4=E13),Parameter_5,0))}, but when I try to use the same formula to find the MIN with multiple conditions as:
{=MIN(IF((Parameter_3=D13)*(Parameter_4=E13),Parameter_5,0))}, it gives for sure "0", what is the trick to find the MINIMUM value with multiple conditions, as the minimum in my reference column is not "0" but "8" ???

Thanks for help

 

[Somendra Misra]

Hi Normand,

Remove the 0 from the false condition of the formula, as it will put 0 wherever the condition not met and minimum will be 0.

Regards!

 

[Normand]

Hi Normand,

Remove the 0 from the false condition of the formula, as it will put 0 wherever the condition not met and minimum will be 0.

Regards!

Hi Misra,
it does not work, the result is still 0 while the minimum value of my data suite is 8....

Normand

 

[Xiq]

Hi Normand,

I believe Somendra Misra was correct, but forgot to mention you also should leave out the last comma.

{=MIN(IF((Parameter_3=D13)*(Parameter_4=E13),Parameter_5))}

 

[Normand]

Hi Normand,

I believe Somendra Misra was correct, but forgot to mention you also should leave out the last comma.

{=MIN(IF((Parameter_3=D13)*(Parameter_4=E13),Parameter_5))}

Hi 5778..

you are right, removing the last comma ended with the right result, thanks.
Normand