Forum Discussion

Mindset001's avatar
Mindset001
Copper Contributor
Sep 21, 2023

Is this a bug or am i just being dumb?

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?
  • LeonPavesic's avatar
    Sep 21, 2023

    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

Resources