Forum Discussion
Peevil
Oct 02, 2020Copper Contributor
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 column B continually count up so each time it passes "North" say, it adds another 360 or set value ( 100 in my example) so that the values continue to increase from the previous cell. IE: 2.5 times around the circle would result in "250". SUM does not work, it gives erroneous results for what I need. I don't even know if this is possible without VBA or some sort of code but that's way beyond my capability (and then I'd be unable to t/s or modify it). TIA!
5 Replies
- Deleted
B2 and copy down
=IFERROR(A2+IF(A2<A1,B1-A1+100,B1-A1),A2)
- PeevilCopper ContributorWow, that was fast, Big Thanks! I see where I went wrong, too.