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!
|