Counting steps in a scale

  • Thread starter Thread starter DirkG
  • Start date Start date
D

DirkG

Hello,

I've been searching for an option in Excel which counts the steps between
scales.

For instance; -1 to 1 is 2 steps (-1 to 0 is 1 step, 0 to 1 is 1 step).

Is there actually an option available in Excel 2003 which provides this
feature?

Hope any of you can help.

Thanks for the time.

Dirk
 
Hi,

If you just want to enter numbers space in Any steps enter the first two
number is two adjacent cells, lets say -1 into A1 and 1 into A2. Highlight
both and drag the fill handle down.

All evenly spaced numerical or date sequences can be produced this way.
 
Great! Thanks for the quick reply.

Another question (in the same category) tho, when a scale goes down from 6
to 3 equals to minus 3 steps. Is it possible to deduct these steps from the
previous calculation?

For instance;

a1 contains -1, a2 contains 1, a3 contains -2
a1 to a2 is plus 2 steps but a2 to a3 is minus 3 steps which should result
in 2 steps minus -3 steps with an end result of -1.

Am I being difficult here?

thanks for your time.

Dirk



=abs(a1-a2) should output 2, =abs(a2-a3)
 
If you are replying to someone else's message, please quote enough of their
message to put your reply into context.

=A2-A1 gives you your +2 steps
=A3-A2 gives you your -3 steps
To get your -1 step you can either use =A3-A1 or you can put the above
formulae into cells, such as B2 and B3, and then use =B2+B3 to give you
your -1.
 
Back
Top