Spreadsheets-Excel or 123

  Abel 10:48 31 Aug 2006

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


  VoG II 11:09 31 Aug 2006

You need to actually round them


then sum the rounded values.

  VoG II 11:25 31 Aug 2006

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

  Abel 11:55 31 Aug 2006

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


  VoG II 12:03 31 Aug 2006

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 2006

Understood! Thanks again.

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Creative studio Omnibus' brand identity for We Said Enough, a non-profit against sexual misconduct

What to ask Siri on the HomePod

Meilleurs VPN (2018)