Is this a bug or am i just being dumb?

[Mindset001]

Short	1	2	3
Lots	1.5	0	-0.1875
Sum Position Sell	1.5	0.00	3

in C3 the formula is =B3+C2??

if I change it to =B3 it comes up with 1.5 so how is 1.5+0 = 0?

[#2 · Accepted solution]

Hi @Mindset001,

It is not a bug and you are definitely not dumb. It is the limitation of the precision of the software.

The number -0.1875 is rounded to 0 because the spreadsheet software uses a limited number of digits to represent numbers.

To see this, you can try changing the format of cell C3 to "Number" with 15 decimal places. You will see that the value of cell C3 is actually -0.187500000000001.

To fix this, you can use the ROUND function to round the value of cell C3 to the desired number of decimal places. For example, to round the value of cell C3 to 2 decimal places, you would use the following formula:

=ROUND(C3, 2)

This would result in the value of cell C3 being displayed as 1.50.

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic

[#3]

@LeonPavesic 

Thanks - I realised it about 5 minutes after I had posted but appreciate the quick response.

I simply needed to format the cell differently and voila!