Display lower of two values

[RodneyW]

I need to adjust this formula C21+($I3+($I3*$D11)) so itwill either display the results of this calculation OR the value in J3, whicheveris lower.

Thanks in advance

 

[Fluff]

How about
=MIN(C21+($I3+($I3*$D11)),J3)

 

[jtakw]

Hi,

Try:

=MIN(J3,C21+$I3+$I3*$D11)

You don't need the extra brackets.

 

[RodneyW]

Worked perfect. thanks

 

[Fluff]

You're welcome & thanks for the feedback

 

[jtakw]

You're welcome.