How do you limit the result of a formula to a specific amount (re.

[M Roberts]

In Excel, how do you limit the result of a formula to a specific amount
(return a result that is no larger than X)?

 

[Alan]

As an example, with A1=100 and A2=200 and the limit being 5000, formula in
A3 :-
=IF(A1*A2>=5000,5000,A1*A2)
Regards

 

[Frank Kabel]

Hi
use
=MIN(X,your_formula)

 

[Bob Umlas]

if x is 500, then
=MIN(500,A1*A2)
Bob Umlas
Excel MVP