| 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 |
| 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 | |||
Threaded Mode
