View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excell-ent Excell-ent is offline
external usenet poster
 
Posts: 2
Default round a 15 digit decimal down from .05

What code to use to round a 15 digit decimal down if it's less than .05 and
up if it's over that in EXCEL.

My work does calculations in grams.

Also, need to know how to divide the above number by 100 to get a per cent
of total weight .

I'm tending to want to use MOD, MROUND and INTEGER.