round a 15 digit decimal down from .05

[Guest]

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.

 

[Jerry W. Lewis]

In Excel
=ROUND(x,1)
or in VBA
Application.Round(x,1)

Jerry

 

[Guest]

I'll try it and get back to you. Thanks. What about the cell that makes a
percent from dividing two cells of the grams with 15 digits - please answer
in both Excel and VBA.

 

[Jerry W. Lewis]

The meaning of that part of your question is not entirely clear, but
here are some observations that may help with what you are asking.

"/" does division in both Excel and VBA, as in
=A1/100
or in VBA
ratio = [A1] / 100

In Excel, you can format a decimal fraction as a percent either by
pressing the % button on the Formatting toolbar, or by
Format|Cells|Number|Percentage.

You have not said what anything in your post has to do with weights, but
=componentWt/TotalWt
formatted as percentage would be percent total weight.

Jerry