Excel rounding problem???

  Monoux 11:36 04 Jun 06
Locked

I have the same figures in a column and on a seperate worksheet in a row. The formula to add them gives a slight difference in total. I suspect this is due to 'Rounding.' Can anybody point me to a way of making excel add up just the figures as shown??

  Noldi 11:40 04 Jun 06

=Roundup() or =Rounddown()
is what you are looking for I think
Noldi

  Noldi 11:42 04 Jun 06

Sorry dindnt read it correct I think you are just looking for =Round()
Noldi

  VoG II 11:54 04 Jun 06

Say you are displaying to 2 decimal places then

=ROUND(A1,2)+ROUND(B1,2)

should give the desired results, as Noldi said.

  Monoux 15:12 04 Jun 06

Thank you both for your thoughts.
I knew from way back when there was a way to only calculate using the figures as displayed but could not for the life of me remember it.
Whilst your suggestions work there is another way. TOOLS/OPTIONS/CALCULATE then tick the box Precision as displayed. Problem Solved

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…