| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I round a formula result to the next integer?
I'm doing formula linking two worksheets together and, once the result is
found, I need to round to the nearest integer by 5's. Example: =('[Canton Erectors Rate Worksheet111]Crane Rates Worksheet'!$B$16*2)*(1+'[Canton Erectors Rate Worksheet111]Crane Rates Worksheet'!$B$31) The answer as is equals 218 but needs to be rounded to 220. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380 | Excel Worksheet Functions | |||
| ROUND the result of a formula | Excel Worksheet Functions | |||
| how to round down the result of a formula | Excel Worksheet Functions | |||
| how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
| How to round up the result in a cell containing formula | Excel Worksheet Functions | |||
Threaded Mode
