Does anyone know how to convert this logic tree into a formula?
Check if D2="1" & E2="L"
IF D2="1" & E2="L" check if D3="2". IF D3 <> 2 THEN: N2=""
-----------------------------------IF D3 = 2 check if J3 >-191
--------------------------------------------------------------IF J3<-191 check if D4=3.
---------------------------------------------------------------------------------------IF D4<>3 THEN: N2=""
---------------------------------------------------------------------------------------IF D4 = 3 check J4.
----------------------------------------------------------------------------------------------------------IF J4 <-191 THEN: N2=""
----------------------------------------------------------------------------------------------------------IF J4 >-191 THEN: N2=K4
--------------------------------------------------------------IF J3>-191 check if E3=W.
---------------------------------------------------------------------------------------IF E3<>W check J4.
----------------------------------------------------------------------------------------------------------IF J4 <-191 THEN: N2=K3.
----------------------------------------------------------------------------------------------------------IF J4 >-191 THEN: N2=((k4*3)+k3)
---------------------------------------------------------------------------------------IF E3= W THEN: N2=K3
Bookmarks