too many numbers after decimal points

I have a simple formula that calculates the sum of 6 cells. The result is displayed in a cell with 0 numbers after the decimal point.


I’m trying to compare the results cell with others to give a Higher, Lower, Same output in a different cell. Despite the zero decimal point settings in the cells, the actual value contains many numbers after the decimal point. So, the formula result is actually 159.983516432 for example whilst 156 is shown in the cell. My comparisons therefore are almost impossible to calculate automatically because of all the extra numbers after the decimal point.


Can anyone suggest how I can avoid this please? I just want the total of the 6 cells to be an EXACT number not one long string of numbers.


Thanks and kind regards,


Cliff

BRIGHTON, UK

iMac 27″, macOS 10.15

Posted on Aug 5, 2024 10:31 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 5, 2024 10:43 AM

Use the ROUND function in the calculated cell to round to zero decimals. For instance:

ROUND(SUM(…), 0)

Where SUM(…) is your original sum of the 6 cells.

Similar questions

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

too many numbers after decimal points

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.