calculating step values between 2 numbers

I

ilana

I am trying to calculate the step values between a known minimum number and a
known maxiimum numbers
Any ideas ?
 
C

Carlo

Hi Ilana

do you know how many steps you have? or how big the steps are?
One of those Numbers is mandatory to calculate the other one!

It would be best if you could give us some example.
That way we can figure out much easier what you mean.

Carlo
 
R

Ragdyer

When you say "calculate", are you talking about totaling?

If you are,
with starting number in A1, and ending number in B1, and a step value of 1:

=(B1-A1+1)*(A1+B1)/2

If step value other then 1, enter it in C1, then:

=((B1-A1)/C1+1)*(A1+B1)/2
 
R

Ragdyer

If you're *not* talking about totaling,
And mean simply *count* the instances,
use the part of the formulas before the asterisk:

Step value of 1:
=B1-A1+1

Step value other then 1, entered in C1:
=((B1-A1)/C1+1)
 
Top