How to have Excel only use 2 decimal places when calculating formu

G

Guest

I have a spreadsheet that I use for quoting.
When I format the cells as accounting, it shows only 2 decimal places, but
it calculates using more (4 I beleive).

Is there a way to tell Excel to round to 2 decimal places and use the result
in future calculations?

Thanks, how this makes sense.

Brian
 
J

JulieD

Hi Brian

you can round the result of a formula to 2 decimal places by using the round
function
=ROUND(your_formula,2)
Excel will then use the rounded value in future calculations

Cheers
JulieD
 
G

Guest

Thanks JulieD, you made my 'D'ay!

JulieD said:
Hi Brian

you can round the result of a formula to 2 decimal places by using the round
function
=ROUND(your_formula,2)
Excel will then use the rounded value in future calculations

Cheers
JulieD
Click to expand...
 

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

Sum of numbers with only two decimal places wrong 2
Convert 10 Decimal Places to 2 3
Decimal Places 4
Decimal rounding causing addition errors 2
worksheet is set up for 2 decimal places but format changes 2
Excel adds phantom decimal places: why? 1
Format a worksheet to carry out all calculations to 2 decimal plac 2
Excel Stop Excel from displaying rounded values 4

Top