I want to increase the numeric value of a cell
output, based on the contents of another cell
input that will contain a binary value. I'd like to do this without using scripts.
Cell B5 is going to alternate between TRUE and FALSE. When B5 changes from FALSE to TRUE I want B6 to increment by 1.
The goal I'm trying to achieve could be thought of as a clock cycle counter with
output being the display of completed cycles and
input alternating between 0 and 1 as the clocking signal.
The overall goal is to run a trigger when B6
output's value is changed.
- B1 is the total distance elapsed
- B2 is the distance interval between scheduling services
- B3 is manually updated with the current value of B1 when the last service was performed. This may not be evenly divisible by B2; it could happen before or after the desired interval elapses.
- B4 Is the distance remaining until the next service should be scheduled B3 + B2 - B1
inputis FALSE when (B2 + B3) < B1 and TRUE when (B2 + B3) >= B1
The document is the page
Service in the linked spreadsheet