That's an arithmatic sequence, so....by Mike Goyette (no login)
I'd need to see the the input functions that make your CASE variable.
Basically, you are going to find the mod (remainder of) a division and determine if it is even or odd, so you will need two formulas.
Show me the functions that make the number you use in the case statement, and I will give you a formula that can do that.
|Response Title||Author and Date|
|Case in extenso||Lisztfr on Feb 15|
|*CASE 97 to 102 : Isize = 168 not 167 , then add one to the rest.||roy on Feb 15|
|Sure i mad an error on this lol||Lisztfr on Feb 15|
|DON'T SPEED UP TheBOB!||on Feb 16|