Forum Discussion

Peevil's avatar
Peevil
Copper Contributor
Oct 02, 2020

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

  • B2 and copy down

    =IFERROR(A2+IF(A2<A1,B1-A1+100,B1-A1),A2)

     

    • Peevil's avatar
      Peevil
      Copper Contributor
      Wow, that was fast, Big Thanks! I see where I went wrong, too.
      • Peevil's avatar
        Peevil
        Copper Contributor

        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 

Resources