Welcome Guest
You last visited December 4, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

# excel formula problem

Topic closed. 2 replies. Last post 12 years ago by reddog.

 Page 1 of 1
Greensboro, North Carolina
United States
Member #1616
June 5, 2003
1283 Posts
Offline
 Posted: February 27, 2005, 2:06 pm - IP Logged

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),34

what should I do differently to keep 0 from popping up?

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: February 27, 2005, 9:50 pm - IP Logged

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

Greensboro, North Carolina
United States
Member #1616
June 5, 2003
1283 Posts
Offline
 Posted: February 27, 2005, 9:59 pm - IP Logged

Thank you Sir Metro.

 Page 1 of 1