Section 1,
Lesson 1
In Progress
Live Q&A Meeting – January 2021 – Part 2
Responses
You must be logged in to post a comment.
You must be logged in to post a comment.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
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
Thanks for following up, Lou!