Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 16 Nov 2025 21:41:13 +0000

[User Discussion] - Spreadsheeet formula isnt incrementing

View Count: 111

[Page 1 of 1] First Page -- 1 -- Last Page

[2025-10-24 23:42:49] #1 [Go To First Post]
User48838 - Posts: 128
=if(or(X10498>O10498), Y10499+1, max(0,Y10499)), see attached, X=448, O=400, Y isnt incrementing, is it the OR? Date Time Of Last Edit: 2025-10-24 23:44:41
0x Thank you
Increment.png / V - Attached On 2025-10-24 23:42:29 UTC - Size: 10.91 KB - 23 views

[2025-10-26 20:59:01] #2 [Go To First Post]
Sawtooth - Posts: 4288
That formula should increment the previous value when TRUE. The OR statement isn't needed, but it shouldn't matter. With cell Y10498 highlighted, click on the Details button in the upper right corner of the spreadsheet sheet. This will give you the calculation details.
0x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page