The no. of decimal places used in a calculation

  • Thread starter Thread starter Chisel
  • Start date Start date
C

Chisel

Without usign ROUNDUP or DOWN , is it possible to calculate a formul
using the figure shown in the cell (i.e 2 decimal places) rather tha
the underlying figure which could be to many more places?

How many decimal places does Excel work to
 
Hi

I believe Excel works to 15 decimal places. If you only want to use the
places shown on your sheet you'll need to go to Tools / Options /
Calculation and check 'Precision as displayed'. Be warned, this will lose
all the other decimal places and you cannot undo this to get them back!
 
for two decimal places you could try (int((N*100)+50))/100
where N is the number you want to result in two decimal places.
 
Back
Top