How do I round a formula result to the next integer?

[LBurlingame]

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.

 

[Mike H]

Try this

=ROUND(yourformula/5,0)*5

Mike

 

[Eduardo]

Hi
Try
=MROUND(('[Canton Erectors Rate Worksheet111]Crane Rates

Worksheet'!$B$16*2)*(1+'[Canton Erectors Rate Worksheet111]Crane Rates
Worksheet'!$B$31) ,5)

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.

 

[HARSHAWARDHAN. S .SHASTRI]

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]

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?

 

[Luke M]

=CEILING(yourformula,5)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

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?

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.

 

[LBurlingame]

Bingo! Thanks a ton!

=CEILING(yourformula,5)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

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?

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.

 

[Bernard Liengme]

=ROUNDUP(yourformula/5,0)*5

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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?

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.

 

[Shane Devenshire]

Hi,

Try:

=ROUND((D11/5)+0.49,)*5


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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?

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.