Max Number in Formula
 

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!

Max Number in Formula
 

=min(125,a1*b1)

(adjust the ranges to match the cells you need)

Kate wrote:

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

Max Number in Formula
 

=MIN(A1*B1,125)

Regards

Trevor


"Kate" wrote in message
...
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!