Section 1, Lesson 1
In Progress

Live Q&A Meeting – January 2021 – Part 2

Responses

  1. This is Lou. I just did a search about the strange decimal errors I sometimes get. Oh, boy. It may be due to the floating point precision issue. One option is to use the ROUND() function, as Jon mentioned. Another is to check Precision as Displayed on Excel Preferences or Advanced Options, but that is a permanent edit once the workbook is saved so think hard before using it. For more info: https://techcommunity.microsoft.com/t5/excel/really-weird-decimal-amounts/m-p/143304