The no. of decimal places used in a calculation

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
 
A

Andy B

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!
 
K

Kempy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for decimal point 4
Excel Stop Excel from displaying rounded values 4
Rounding calculation to ONLY two deci places 5
Decimal Places 1
Limitations to # of Decimal places for seconds (time)? 1
Excel error in converting decimal to fraction 3
A lot of Decimal Places 5
Decimal places in mail merge 1

Top