View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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!