Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

Is this a bug or am i just being dumb?

Copper Contributor
Short123
Lots1.50-0.1875
Sum Position Sell1.50.003

 

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 Replies
best response confirmed by Mindset001 (Copper Contributor)
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

@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!

1 best response

Accepted Solutions
best response confirmed by Mindset001 (Copper Contributor)
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

View solution in original post