Section 1, Lesson 1
In Progress

Live Q&A Meeting – January 2021 – Part 2

Responses

Your email address will not be published. Required fields are marked *

  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