| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
Try this
=ROUND(yourformula/5,0)*5 Mike "LBurlingame" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
Hi
Try =MROUND(('[Canton Erectors Rate Worksheet111]Crane Rates Worksheet'!$B$16*2)*(1+'[Canton Erectors Rate Worksheet111]Crane Rates Worksheet'!$B$31) ,5) "LBurlingame" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
Hi LBurlingame,
Try following formula =IF(MOD(Your formula,5)=0,your formula,(INT((your formula/5)+1)*5)) H S Shastri Pl press yes if found useful. ++++++++++++++++++++++++++++++++++++++++++++++++++ +++++ "LBurlingame" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
All of those rounded to the nearest 5 for me - thanks. Now here's another
kink in the works. Is there a way to always round UP to the nearest 5? "LBurlingame" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
=CEILING(yourformula,5)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "LBurlingame" wrote: All of those rounded to the nearest 5 for me - thanks. Now here's another kink in the works. Is there a way to always round UP to the nearest 5? "LBurlingame" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
Bingo! Thanks a ton!
"Luke M" wrote: =CEILING(yourformula,5) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "LBurlingame" wrote: All of those rounded to the nearest 5 for me - thanks. Now here's another kink in the works. Is there a way to always round UP to the nearest 5? "LBurlingame" wrote: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
=ROUNDUP(yourformula/5,0)*5
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LBurlingame" wrote in message ... All of those rounded to the nearest 5 for me - thanks. Now here's another kink in the works. Is there a way to always round UP to the nearest 5? "LBurlingame" wrote: 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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a formula result to the next integer?
Hi,
Try: =ROUND((D11/5)+0.49,)*5 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "LBurlingame" wrote: All of those rounded to the nearest 5 for me - thanks. Now here's another kink in the works. Is there a way to always round UP to the nearest 5? "LBurlingame" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
