G Guest Oct 25, 2007 #1 I am trying to calculate the step values between a known minimum number and a known maxiimum numbers Any ideas ?
I am trying to calculate the step values between a known minimum number and a known maxiimum numbers Any ideas ?
G Guest Oct 25, 2007 #2 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
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 Oct 25, 2007 #3 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
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 Oct 25, 2007 #4 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)
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)
