I'm looking for one formula or multiple formulas working together that cause a single iteration on a cell no matter how many iterations the workbook is set to do. This is hard to explain in words, but I can try to give an example:
Toggle Button linked to A1 (trying to do this as a macro-free book)
B1: =If(A1,C1+1,B1)
C1: =B1
If I have this set to iterative calculations with 100 iterations, this will go up by 100 each time. I want it to go up by 1 each time (and no I don't mean just divide by 100). I want to know that every time I toggle the button to TRUE, I can get ONE result, but I also want the workbook to be on iterative calculations.
Any thoughts?
Toggle Button linked to A1 (trying to do this as a macro-free book)
B1: =If(A1,C1+1,B1)
C1: =B1
If I have this set to iterative calculations with 100 iterations, this will go up by 100 each time. I want it to go up by 1 each time (and no I don't mean just divide by 100). I want to know that every time I toggle the button to TRUE, I can get ONE result, but I also want the workbook to be on iterative calculations.
Any thoughts?
