Support Board
Date/Time: Wed, 26 Feb 2025 21:54:45 +0000
Post From: Spreadsheet formula outputs
| [2021-05-29 19:46:40] |
| User93534 - Posts: 30 |
|
[ IF ] IF(AND(AF433=1,OR(AB432-AA432>=1.75,AB432>=AA43... = AF433 (reference) [ AND ] AND(AF433=1,OR(AB432-AA432>=1.75,AB432>=AA432+(... = 0 (number, integer) [ = ] AF433=1 = 1 (number, integer) [ AF433 ] AF433 = 1 (number, integer) [ 1 ] 1 = 1 (number, integer) [ OR ] OR(AB432-AA432>=1.75,AB432>=AA432+(S432-AA432)*... = 0 (number, integer) [ >= ] AB432-AA432>=1.75 = 0 (number, integer) [ - ] AB432-AA432 = 1.75 (number, double) [ AB432 ] AB432 = 4215 (number, integer) [ AA432 ] AA432 = 4213.25 (number, double) [ 1.75 ] 1.75 = 1.7500000000000002 (number, double) getting a negative output on 4215-4213.25 >=1.75, I changed the formula to AB3-AA3>=FLOOR(1.75,25)to get it to work but this is seriously annoying and problematic. Why did sierra add .0000000000000002 to my given value? I am spending hours debugging all these formulas on triggers to find the software is just making up its own stuff. Do I have some settings or something that is causing this or is it the software itself? |