Thread: How do I round a formula result to the next integer?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default 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.
Reply With QuoteReply With Quote