IF Statement with 3 parameters
 

D22 = 508 kg
B19 = $35.00 (minimum)
C19 = $.25
D19 = $275.00 (maximum)

Problem:
if D22*C19< then B19
if D22*C19 greater than B19, but less than D19, D22*C19
if D22*C19D19 then D19

How do I construct the nested IF statement?

IF Statement with 3 parameters
 

Your first parameter is not clear. If D22*C19 < ???

Generally, these formulas have the form
=IF(A1<A2,A3,IF(A4<A5,A6,IF(A7<A8,A9,""))) etc.

IF...THEN...ELSE IF...THEN...ELSE IF...THEN...ELSE

Dave
--
Brevity is the soul of wit.


"Teri" wrote:

D22 = 508 kg
B19 = $35.00 (minimum)
C19 = $.25
D19 = $275.00 (maximum)

Problem:
if D22*C19< then B19
if D22*C19 greater than B19, but less than D19, D22*C19
if D22*C19D19 then D19

How do I construct the nested IF statement?

IF Statement with 3 parameters
 

Thanks for catching that!! Should be <B19

"Dave F" wrote:

Your first parameter is not clear. If D22*C19 < ???

Generally, these formulas have the form
=IF(A1<A2,A3,IF(A4<A5,A6,IF(A7<A8,A9,""))) etc.

IF...THEN...ELSE IF...THEN...ELSE IF...THEN...ELSE

Dave
--
Brevity is the soul of wit.


"Teri" wrote:

D22 = 508 kg
B19 = $35.00 (minimum)
C19 = $.25
D19 = $275.00 (maximum)

Problem:
if D22*C19< then B19
if D22*C19 greater than B19, but less than D19, D22*C19
if D22*C19D19 then D19

How do I construct the nested IF statement?

IF Statement with 3 parameters
 

Teri a écrit :
D22 = 508 kg
B19 = $35.00 (minimum)
C19 = $.25
D19 = $275.00 (maximum)

Problem:
if D22*C19< then B19
if D22*C19 greater than B19, but less than D19, D22*C19
if D22*C19D19 then D19

How do I construct the nested IF statement?





Hi Teri,

Can also be =min(D19,max(B19,(D22*C19)))

Regards
FxM

IF Statement with 3 parameters
 

Perfect! Thank you!!

"FxM" wrote:

Teri a écrit :
D22 = 508 kg
B19 = $35.00 (minimum)
C19 = $.25
D19 = $275.00 (maximum)

Problem:
if D22*C19< then B19
if D22*C19 greater than B19, but less than D19, D22*C19
if D22*C19D19 then D19

How do I construct the nested IF statement?





Hi Teri,

Can also be =min(D19,max(B19,(D22*C19)))

Regards
FxM