Welcome Guest
Log In | Register )
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
PrintE-mailLink
reddog's avatar - patch
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?

    SirMetro's avatar - center
    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

      reddog's avatar - patch
      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.