Spreadsheets-Excel or 123

  Abel 10:48 31 Aug 2006
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 2006

You need to actually round them

=ROUND(A1,2)

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?

Abel

  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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?