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