Maximum number of decimals used in calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set either a global default or a cell format that only uses the decimal places visible in the cell for calculations? Rounding won't work because it occurs after the calculation

thanks
Jack
 
Hi
goto 'Tools - Options - Edit' and choose a fixed number of decimals.
Note: This will CHANGE all your data in this workbook irreversible!
 
Do I understand you to want to be able to take a cell containing, for
example, 2.25, and multiply it by 2, and obtain the result of 0.5?

And, if you multiply that 2.25 cell by another 2.25 cell, the result will be
0.0625?

If that be the case, then you need to incorporate this action into each and
every individual formula.

To obtain the decimal part of a cell you could use MOD().
For example, in the above scenario, with A1 and A2 containing 2.25,
This will multiply the the decimal portions of the two cells:
=MOD(A1,1)*MOD(A2,1)
to obtain 0.0625.

To add a column of decimal only values, you could try:
=SUM(MOD(A1:A10,1)),
which is an array formula and *must* be entered and edited with CSE (<Ctrl>
<Shift> <Enter>, which will automatically enclose the formula in curly
brackets.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do I set either a global default or a cell format that only uses the
decimal places visible in the cell for calculations? Rounding won't work
because it occurs after the calculation.

thanks,
Jack
 
Back
Top