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

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

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

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.
--
Thanks,
Shane Devenshire


"DirkG" wrote:

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

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

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