Anyone know how to keep values increasing referencing another column?

%3CLINGO-SUB%20id%3D%22lingo-sub-1739134%22%20slang%3D%22en-US%22%3EAnyone%20know%20how%20to%20keep%20values%20increasing%20referencing%20another%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739134%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20example%20is%20based%20on%20100%20but%20you%20could%20also%20do%20it%20in%20degrees%20like%20a%20compass%20rose.%20I%20have%20a%20list%20in%20%22A%22%26nbsp%3B%20of%20values%20that%20basically%20depict%20points%20that%20go%20around%20a%20circle.%20I%20need%20to%20have%20the%20result%20column%20B%20continually%20count%20up%20so%20each%20time%20it%20passes%20%22North%22%20say%2C%20it%20adds%20%3CEM%3Eanother%20%3C%2FEM%3E360%20or%20set%20value%20(%20100%20in%20my%20example)%20so%20that%20the%20values%20continue%20to%20increase%20from%20the%20previous%20cell.%20IE%3A%202.5%20times%20around%20the%20circle%20would%20result%20in%20%22250%22.%20SUM%20does%20not%20work%2C%20it%20gives%20erroneous%20results%20for%20what%20I%20need.%20I%20don't%20even%20know%20if%20this%20is%20possible%20without%20VBA%20or%20some%20sort%20of%20code%20but%20that's%20way%20beyond%20my%20capability%20(and%20then%20I'd%20be%20unable%20to%20t%2Fs%20or%20modify%20it).%20TIA!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1739134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739208%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20know%20how%20to%20keep%20values%20increasing%20referencing%20another%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739208%22%20slang%3D%22en-US%22%3E%3CP%3EB2%20and%20copy%20down%3C%2FP%3E%3CP%3E%3DIFERROR(A2%2BIF(A2%3CA1%3E%3C%2FA1%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739260%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20know%20how%20to%20keep%20values%20increasing%20referencing%20another%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739260%22%20slang%3D%22en-US%22%3EWow%2C%20that%20was%20fast%2C%20Big%20Thanks!%20I%20see%20where%20I%20went%20wrong%2C%20too.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739333%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20know%20how%20to%20keep%20values%20increasing%20referencing%20another%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739333%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20working%20with%20that%20I%20realize%20I%20spoke%20too%20soon%2C%20that%20doesn't%20work%2C%20it's%20only%20referencing%20the%20B%20column%20I%20put%20in%20manually.%20I%20need%20the%20formula%20to%20actually%20generate%20that%20B%20column%20correctly!%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817105%22%20target%3D%22_blank%22%3E%40Peevil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

B2 and copy down

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

 

Highlighted
Wow, that was fast, Big Thanks! I see where I went wrong, too.
Highlighted

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.
Highlighted
Ah, I see, I must've done it wrong because I kept getting REF! errors or all "0", I got it, it works! Thank You so much! (and you make it look easy, lol!)