Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 11:29:30 +0000



Post From: Formula for once column K has a true signal, it can not repeat a true signal until column L has

[2014-04-22 23:07:37]
vegasfoster - Posts: 444
Maybe you already got this figured, but maybe try,

in O3, =if(K3=true, 1, if(L3=true, 2, O4))
in K3, =and(original entry formula, O4=2)
in L3, =and(original entry formula, O4=1)