Formula adding 7 decimal places to result

[JohnZ1156]

I think I have what is a simple formula that takes values of separate cells and totals them.
This formula is in G756.
=IFERROR(G755-B756+C756+D756+E756,G755-B756+C756+E756) (if error occurs, omit cell in column D)
I checked the results in each of the individual cells, and they all come to an answer with 2 decimal places or less,
but the result of this formula shows me 170623.070000001.
It should simply be 170623.07. Where is the "0000001" coming from?

Must I use the ROUND function for all of the cells in column G?
ex: =IFERROR(ROUND(G755-B756+C756+D756+E756,2),ROUND(G755-B756+C756+E756,2))

 

[BigBeachBananas]

You have tried doing this on the Home tab?

 

[Scott Huish]

It's because of how computers do math. It's called floating point arithmetic and here is an article about it:
Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps

 

[Joe4]

View attachment 100189

You have tried doing this on the Home tab?

Note that will only changed the displayed value, not what is actually stored in the underlying cells, which could be problematic in calculations.

The issue is explained in the article Scott linked.
The two most common solutions to it are:
1. To use the ROUND function
2. To use the "Precision as displayed" setting
Both options are described in the linked article.