I'm struggling to create a formula that will count positive or negative numbers based off of 0.
Example: I have a column with 30 rows. If I put a zero in A10 I want A9 to show -1, A8 -2, etc. and A11 to show 1, A12 2, etc.. If I later put the zero in A15 then A14 should be -1, A16 1, and so on.
Make sense?
Example: I have a column with 30 rows. If I put a zero in A10 I want A9 to show -1, A8 -2, etc. and A11 to show 1, A12 2, etc.. If I later put the zero in A15 then A14 should be -1, A16 1, and so on.
Make sense?