Max Number in Formula

[Kate]

If Column A = 12, Column B is an enter only data(i.e. 13), Column C = A*B /
the return in Column c would be 156 however what if anything over 125 would
just display the high number of 125? Hope this makes sense!

 

[Dave Peterson]

=min(125,a1*b1)

(adjust the ranges to match the cells you need)

 

[Trevor Shuttleworth]

=MIN(A1*B1,125)

Regards

Trevor