When the decimal is increased the value changes.
Decimal Issues
Just type in the quantities.
Like
233462.79 next cell 237188.24 next cell blank next cell formula the biggest minus the smaller (237188.24-233462.79) and then increase the decimals.
Hi @CarlosMartin-1797,
Your problem may related to the floating-point arithmetic in Excel, I suggest you refer to this support article:
As the article said:
1. You can use the ROUND function to correct the result.
2. You can go to File- Options- Advanced- When calculating this workbook- check the option “Set precision as displayed”
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @CarlosMartin-1797,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
5 people are following this question.
