large number calculations in excel

  gizzyx 07:48 11 Feb 03

when doing a spreadsheet using very large currency figures (over ten trillion pounds!!!), excel does not calculate exactly. it seems to round off. does anyone know how to force it to give exact calculations?

  VoG™ 09:26 11 Feb 03

There is a limit to the number of significant figures that Excel can hold. I ca'nt remember what it is offhand. This is probably why you are getting rounding errors.

  BrianW 11:17 11 Feb 03

further to VoG's observation you may be able to get round the rounding error problem by formatting the column(s) into "Scientific Notation" which will enable you to use more signicant numbers, raised to the necessary power (13 for 10s of trillions if I remember correctly). You would not be able to display the currency format in the column but would get round that by labelling your column with the relevant currency header).

  Ben Avery (Work) 11:30 11 Feb 03


  jazzypop 11:34 11 Feb 03

Excel has a nunber precision limit of 15 figures, according to it's help file.

  pj123 16:49 11 Feb 03

I bet he wishes it was. And I did lol.

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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

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

This stop-frame animation tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…