Spreadsheets-Excel or 123

  Abel 10:48 31 Aug 06
Locked

When using 'Currency' or 'Number' format in Excel or 'Comma' or 'British Pound' in Lotus 123, where values are rounded to the second decimal point, is there a way of preventing the values stored beyond the second decimal point from subsequently being included in totals. For example, £5.376 would be rounded to £5.38 but if you had say five of these identical amounts while ostensibly 5 x £5.38 equals £26.90, 5 x £5.376 equals £26.88

Abel

  VoG II 11:09 31 Aug 06

You need to actually round them

=ROUND(A1,2)

then sum the rounded values.

  VoG II 11:25 31 Aug 06

(and I do not favour this approach) Tools > Options, Calculation tab, tick Precision as displayed.

  Abel 11:55 31 Aug 06

Many thanks for your information VoG™. I'm curious to know why you're not in favour of the 'Precision as displayed' option?

Abel

  VoG II 12:03 31 Aug 06

Using the rounding option it should be obvious to anyone (including the creator of the spreadsheet some time later) what is being done.

Using 'Precision as displayed' is not transparent to others (or the creator for that matter) unless they check in Options - no other indication is given that this option has been selected, other than the warning when this option is first set.

  Abel 12:05 31 Aug 06

Understood! Thanks again.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

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

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…