Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 19:51:45 +0000

How to Post a Message for Support

Post From: Spreadsheet errors

[2018-06-30 11:43:34]
[Go To First Post]
User93534 - Posts: 30
Updated to current version and the problem persists. It calculates correctly in most cases but very clearly misfires on occasion. Tried changing formula a bit and still returns false value.

[ <= ] (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)