Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 15:22:39 +0000

How to Post a Message for Support

Post From: Value not evaluated

[2019-08-14 20:27:51]
[Go To First Post]
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??