Support Board
Date/Time: Mon, 20 Jan 2025 20:44:20 +0000
Post From: Spreadsheet errors
| [2018-07-02 23:10:07] |
| VladimirP - Posts: 647 |
|
The Details calculations for the cell N20 described in the post #1 shows the correct values. specifically the final part that correctly calculates the value initially at 1.5 and then returns a final value of 1.25 [ <= ] (C20-M21)<=1.25 = 0 (number, integer) [ - ] (C20-M21) = 1.5 (number, double) [ C20 ] C20 = 2724.25 (number, double) [ M21 ] M21 = 2722.75 (number, double) [ 1.25 ] 1.25 = 1.25 (number, double) The cell N20 is calculated correctly. What is an algorithm to reproduce the error, described for the cell N20? |