Sep 20 2023 08:14 PM
Sep 20 2023 11:23 PMSolution
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:
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.