Welcome Guest
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
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

thanks again

Bob from Michigan

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

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

 Page 1 of 1