Welcome Guest
Log In | Register )
You last visited December 3, 2016, 6:52 pm
All times shown are
Eastern Time (GMT-5:00)

We need a Formula in EXCEL

Topic closed. 2 replies. Last post 2 years ago by Bob.

Page 1 of 1
51
PrintE-mailLink
Avatar
Michigan
United States
Member #59
November 10, 2000
377 Posts
Offline
Posted: April 25, 2015, 10:38 am - IP Logged

1A---76631534
--------------------
2B---4394687
3C---734156
4D---17562
5E---8328
6F---251
7G--76
---------------------
Need a formula for adding root numbers?
Example:row 1A 7+6=13---1+3=4
So 4 would be the first number in row2B
next in row 1A--6+6=12---1+2=3
So 3 would be next in row 2B and so on till the
last two numbers in row 1A ---3+4=7
need the whole formula --using excel 7
thank you..
we did try the MOD formula but it didn't
add the root number??

thanks again

Bob from Michigan

    frenchie's avatar - Lottery-041.jpg
    Los Angeles
    United States
    Member #75410
    June 2, 2009
    479 Posts
    Offline
    Posted: April 26, 2015, 3:40 pm - IP Logged

    Try this one.

    =1+MOD((A1-1),9)

    Frenchie

      Avatar
      Michigan
      United States
      Member #59
      November 10, 2000
      377 Posts
      Offline
      Posted: April 26, 2015, 8:55 pm - IP Logged

      Hey Frenchie  THANKS  that works just right...

      that is what we were looking for...

      thanks again

      Bob in Michigan