I have a spreadsheet that determines the overal diameter of a cable based on
the number of conductors, insulation, shielding, etc. The result yields a
decimal number. I would like to round that decimal number to the nearest
sixteenth. I know that I can format the cell to fractions, but this does not
actually change the value. I want a new cell to have the exact decimal
equivalent of the nearest sixteenth.

For example, the first column below is the calculated "raw" diameter and
second column is the decimal number of the nearest sixteenth of the raw
diameter.

0.4687 = 0.4375
0.4688 = 0.5000
0.5312 = 0.5000
0.5313 = 0.5625
0.5937 = 0.5625
0.5938 = 0.6250

Thanks in advance for your help.

Mike

I'd say that 50% of the time I end up find my own answer right after
asking...here goes.

If the raw number is in A1 then use the formula =round(A1*16,0)/16

Man that was as simple solution.



"crazybass2" wrote:

I have a spreadsheet that determines the overal diameter of a cable based on
the number of conductors, insulation, shielding, etc. The result yields a
decimal number. I would like to round that decimal number to the nearest
sixteenth. I know that I can format the cell to fractions, but this does not
actually change the value. I want a new cell to have the exact decimal
equivalent of the nearest sixteenth.

For example, the first column below is the calculated "raw" diameter and
second column is the decimal number of the nearest sixteenth of the raw
diameter.

0.4687 = 0.4375
0.4688 = 0.5000
0.5312 = 0.5000
0.5313 = 0.5625
0.5937 = 0.5625
0.5938 = 0.6250

Thanks in advance for your help.

Mike

Ask immediately, it will save you time <vbg

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crazybass2" wrote in message
...
I'd say that 50% of the time I end up find my own answer right after
asking...here goes.

If the raw number is in A1 then use the formula =round(A1*16,0)/16

Man that was as simple solution.



"crazybass2" wrote:

I have a spreadsheet that determines the overal diameter of a cable
based on
the number of conductors, insulation, shielding, etc. The result yields
a
decimal number. I would like to round that decimal number to the
nearest
sixteenth. I know that I can format the cell to fractions, but this
does not
actually change the value. I want a new cell to have the exact decimal
equivalent of the nearest sixteenth.

For example, the first column below is the calculated "raw" diameter and
second column is the decimal number of the nearest sixteenth of the raw
diameter.

0.4687 = 0.4375
0.4688 = 0.5000
0.5312 = 0.5000
0.5313 = 0.5625
0.5937 = 0.5625
0.5938 = 0.6250

Thanks in advance for your help.

Mike