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?