| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit a calculation to a certain number
Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0) I
want to take the answer for that (which happens to be 1051) and say "limit the answer to 1000". In other words, for that column, I want the maximum answer returned to be 1000. Can't be more than that, but it can be under. How would I do that?? Thanks all! -Jon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit a calculation to a certain number
Try this:
=MIN(ROUNDDOWN(C17/10,0),1000) Does that help? *********** Regards, Ron XL2002, WinXP "jlatenight" wrote: Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0) I want to take the answer for that (which happens to be 1051) and say "limit the answer to 1000". In other words, for that column, I want the maximum answer returned to be 1000. Can't be more than that, but it can be under. How would I do that?? Thanks all! -Jon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit a calculation to a certain number
"jlatenight" wrote in message
ups.com... Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0) I want to take the answer for that (which happens to be 1051) and say "limit the answer to 1000". In other words, for that column, I want the maximum answer returned to be 1000. Can't be more than that, but it can be under. How would I do that?? Thanks all! -Jon =MIN(ROUNDDOWN((C17/10),0),1000) Joerg |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit a calculation to a certain number
"Joerg" wrote in message ... "jlatenight" wrote in message ups.com... Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0) I want to take the answer for that (which happens to be 1051) and say "limit the answer to 1000". In other words, for that column, I want the maximum answer returned to be 1000. Can't be more than that, but it can be under. How would I do that?? Thanks all! -Jon =MIN(ROUNDDOWN((C17/10),0),1000) Joerg I just noticed that you could shorten your formula: =MIN(INT(C17/10),1000) INT always rounds down, so it fits the bill in your case. Joerg |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit a calculation to a certain number
=MIN(INT(C17/10),1000) Worked perfectly!!! Thanks everyone who
replied!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation for amt. Exceeding $106,800 for SS Income Limit | Excel Worksheet Functions | |||
| I want to limit the result of a calculation to a maximum number... | Excel Discussion (Misc queries) | |||
| how do I limit the number of coloums? | Excel Discussion (Misc queries) | |||
| Limit of number which sin() can handle? | Excel Worksheet Functions | |||
| Limit on number of conditions? | Excel Worksheet Functions | |||
Hybrid Mode
