excel formula problem

Reply #2

reddog — Mon, 28 Feb 2005 02:59:28 GMT

Thank you Sir Metro.

Reply #1

SirMetro — Mon, 28 Feb 2005 02:50:29 GMT

rewrite your code as follows:=if((MOD(A1+A2),34)=0,1,(MOD(A1+A2),34))In english, test to see if the sum is 0, if yes then let it equal 1, else let it be whatever it will be.Sir Metro

excel formula problem

reddog — Sun, 27 Feb 2005 19:06:56 GMT

I am trying to add to cells together ie, A1+A2 and have it start back to counting from 1 on up once it reaches 34. Problem I am having is some of the cells will total 0 if the sum of two cells equal 34. Pick 5 does not have a 0. It starts from 1 to 34. What string should I be using?Here is the string I am currently using;starting in cell A3=MOD(A1+A2),34what should I do differently to keep 0 from popping up