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

L

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.
 
E

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)

LBurlingame said:
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.
 
H

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.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
L

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?
 
L

Luke M

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

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


LBurlingame said:
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 said:
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.
 
L

LBurlingame

Bingo! Thanks a ton!

Luke M said:
=CEILING(yourformula,5)
--
Best Regards,

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


LBurlingame said:
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 said:
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.
 
B

Bernard Liengme

=ROUNDUP(yourformula/5,0)*5

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

LBurlingame said:
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 said:
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.
 
S

Shane Devenshire

Hi,

Try:

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


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

Cheers,
Shane Devenshire


LBurlingame said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top