ABCDEFGHIJKLM
1
ItemIn StockTotal Used
2
3
FALSE♦FALSE♦FALSE♦FALSE♦FALSE♥TRUE♦TRUE♦TRUE♦FALSE♦FALSETRUE♦TRUE♦TRUE♦FALSE♦FALSE
4
Material 1
➕		29

⬇️
22
🔔 Iterative calculation must be on with max iterations = 1
5
Material 2
➕		2

⬇️
4
6
Material 3
➕		3

⬇️
1
🔔 Formulas in row 2 and row 10 control the output
7
Material 4
➕		1

⬇️
1
8
Material 5
➕		2

⬇️
9
🔔 To reset any value, or if you happen to see a #ref error, just clear the cell and it will become blank or 0
9
10
11
TRUE♦♦FALSE♦FALSE♥TRUE♦TRUE♦TRUE♦TRUETRUE♦TRUE♦TRUE♦TRUE
12
Special 1
➕		1

⬇️
8
🔔 Display on mobile is not consistent
13
Special 2
➕		3

⬇️
2
14
Special 3
➕		3

⬇️
1
🔔 Much faster than apps script
15
Special 4
➕		0

⬇️
0
16