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.
--
David Biddulph


"DirkG" wrote in message
...
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)

"Gary''s Student" wrote:

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

=ABS(A1-A2)
--
Gary''s Student - gsnu200810