Support Board
Date/Time: Wed, 27 Nov 2024 10:26:40 +0000
Post From: Help with New Spreadsheets for non-CLR (Iteration?)
| [2014-08-15 07:49:48] |
| 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
|