- =IF(And(A1<=43; B1>=42; O1<=85);86;O1+B1)
- If (inRastA <= 43) (condition 1) and (inRastB> = 42) (condition2) and (inRastA+inRastB <= 85) (condition3), then the result is (ouRast = 86), otherwise (inRastA+inRastB).
There are 2 conditions in the first
There are 3 conditions in the second
Can you confirm the logic
Using the IF statement as the one that worked:
True = if A1<=43 AND B1 >42 and O1 (A1+B1 <=85) then 86
False = else A1 + B1
So the first checks should be
con 1 , con 2 , True_1&2, False_2, False_1
(A1+B1 < = 85), [ (A1<=43 and B1>=42), True, False], False)
(A1+B1 < = 85), [ (A1<=43 and B1>=42), 86, A1+B1], A1+B1)
(test 1,
True1 [ (test 2,
(True 1 and True 2), 86
True 1, False 2) A1 + B1
False 1 A1 + B1