Max Number in Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=min(125,a1*b1)

(adjust the ranges to match the cells you need)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match value in one column and return value in same row in next col 2
Logical Function 1
Count entries in the column translating to minutes. 5
Array with Sum and multiply 12
Complicated SUM IF formula 2
Formula help 1
Need help with logic or Vlookup formula 9
Find Character in Text and put value in next column 2

Back
Top