Thread: ROUNDUP to nearest 1/16 (in decimals)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default ROUNDUP to nearest 1/16 (in decimals)
=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
Reply With QuoteReply With Quote