| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
| Formula help, chaning a cell number within the formula | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| formula that gives me a random number less than other number | Excel Worksheet Functions | |||
Hybrid Mode
