Support Board

Date/Time: Sun, 19 May 2024 07:52:03 +0000

Post From: Help with New Spreadsheets for non-CLR (Iteration?)

[2014-08-15 07:49:48] Link To Thread - Link To Post [Go To First Post]
User33803 - Posts: 40
Hi, I have a problem with the change from Old Spreadsheets to New Spreadsheets. I use a cell that is blocked to 1 when a first trigger cell has the value 1 and it is released to value 0 when a reset cell has the value 1. The Reset cell only sets to 1 if a second trigger is set to 1, the first trigger is set to 0 and the blocking cell value is 1. This works fine with the Old Spreadsheets but it doesn't work with the new Spreadsheets. Below is an example of this case: First Trigger Cell: AD120 Blocking Cell: AD121 Reset Cell: AD122 Second Trigger Cell: AD123 Cell AD120: switches from 0 to 1 and viceversa Formula in Cell AD121: =IF(AND(OR(AD120=1;AD121=1);AD122=0);1;0) Formula in Cell AD122: =IF(AND(AD120=0;AD121=1;AD123=1);1;0) Cell AD123: switches from 0 to 1 and viceversa Date Time Of Last Edit: 2014-08-15 07:51:03