Thread: ROUNDUP to nearest 1/16 (in decimals)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default ROUNDUP to nearest 1/16 (in decimals)
wrote:
On May 12, 9:34 am, Bernd P wrote:
=ROUNDUP(A2*16,0)/16
will round UP to next 1/16. Take ROUND if you want to round to closest
1/16.

Regards,
Bernd

Thanks, Bernd. I should've been more specific. I need to round the
result of the following function to the nearest 1/16:
=(V5*D5)-AB12+AC12

How can I modify this to round accordingly?


Substitute your function for A2 in Bernd's function.


=ROUNDUP(((V5*D5)-AB12+AC12)*16,0)/16
Reply With QuoteReply With Quote