Forum Discussion
Anyone know how to keep values increasing referencing another column?
The example is based on 100 but you could also do it in degrees like a compass rose. I have a list in "A" of values that basically depict points that go around a circle. I need to have the result co...
B2 and copy down
=IFERROR(A2+IF(A2<A1,B1-A1+100,B1-A1),A2)
- Wow, that was fast, Big Thanks! I see where I went wrong, too.
After working with that I realize I spoke too soon, that doesn't work, it's only referencing the B column I put in manually. I need the formula to actually generate that B column correctly! Peevil
- it will if you start the formula in B2. The "IFERROR" part is to copy the first value into B. After that it will use the values you create.
