Counting steps in a scale

[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

 

[Gary''s Student]

With the first scale item in A1 and the second item in A2, use:

=ABS(A1-A2)

 

[ShaneDevenshire]

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.

 

[DirkG]

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)

 

[David Biddulph]

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.