Support Board
Date/Time: Sun, 02 Feb 2025 07:08:08 +0000
Post From: Value not evaluated
| [2019-08-14 20:27:51] |
| User37462 - Posts: 31 |
|
Hi, I have spreadsheet study, Buy entry cell. Backtest. If the formula is: =AND ((E3>O3),(P3=1)) than P3 is not evaluated - why? Formula details: [ AND ] AND ((E3>O3),(P3=1)) = 0 (number, integer) [ > ] (E3>O3) = 0 (number, integer) [ E3 ] E3 = 3970.75 (number, double) [ O3 ] O3 = 4154.86872253418 (number, double) [ = ] (P3=1) = (not evaluated) If I swap formula in the same moment to : =AND ((P3=1),(E3>O3)) than (E3>O3) is not evaluted -why? Formula details: [ AND ] AND ((P3=1),(E3>O3)) = 0 (number, integer) [ = ] (P3=1) = 0 (number, integer) [ P3 ] P3 = 0 (number, integer) [ 1 ] 1 = 1 (number, integer) [ > ] (E3>O3) = (not evaluated) Seems like it depends on the order?? |