Need explanation of a MAX-MIN formula!

[Pam019]

Hi all

I am working through an excel file which i didn't create myself and am having trouble to understand one particular formula. can someone help me to understand what is the scope of this formula, what is it doing??

=MAX(0,MIN(($H19-$K19-$L19),

where for example:
H19 is 71000
K19 is 0
L19 is 46000


Thanks in advance,

Pam

[xlbiznes]

Hi,

Post the full formula, =MAX(0,MIN(($H19-$K19-$L19), this is only a part of the complete formula.

[RHCPgergo]

Hi Pam, welcome to the forum.

That can't be all of the formula, because it's missing two parenthesises on the right. Maybe you only pasted the left side and there's more?

[Richard Buttrey]

Hello Pam and welcome to the forum

I assume there should be two closing parentheses )) instead of the comma in your function example.
However it may be that this isn't the complete formula, but on the face of it there's no need to wrap h19-k19-l19 in a MIN function since there's no second or third parts to the minimum to evaluate. A normal MIN function would look like =MIN(cell1,cell2,cell3.....etc).

Assuming there had been the Min function would return the lowest value.

The whole function is then wrapped in a MAX(0,MIN()) function so that if the MIN function had been > 0 then the whole function would have been limited to zero.

[Pam019]

Thanks to all of you. Yes i didn't post all the formula because that's the only part i'm not understanding...but this is the whole formula

=IF(AND($H19>0,$I19>0,$J19>0),
MAX(0,MIN(($H19-$K19-$L19),
IF($I19="SL",(($H19-$K19)/$J19*M19),
IF($I19="150% DDB",MAX(($H19-$K19-L19)/$J19*1.5*M19,($H19-$K19)/$J19*M19),
IF($I19="200% DDB",MAX(($H19-$K19-L19)/$J19*2*M19,($H19-$K19)/$J19*M19)))))),"")

[Pam019]

I will be always using I19 as being = SL, so the last two parts of the formula are not important to understand.

[Richard Buttrey]

I will be always using I19 as being = SL, so the last two parts of the formula are not important to understand.

In that case

=IF(AND($H19>0,$I19>0,$J19>0),MAX(0,MIN($H19-$K19-$L19)))

should be sufficient. The explanation is still as per psot # 4.

It's always important to let is have all relevant details otherwise you just make things harder for everyone.