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