Welcome Guest
You last visited October 22, 2017, 11:31 am
All times shown are
Eastern Time (GMT-5:00)

# A Little Help With Excel Please!!

Topic closed. 4 replies. Last post 11 years ago by NIAN07.

 Page 1 of 1
WILLIAMSTOWN,KY
United States
Member #812
October 26, 2002
28 Posts
Offline
 Posted: July 16, 2006, 5:07 pm - IP Logged

Hi

For p3--

199 should it be =a+b+c(d+e)(f+g=([total])<=9>=1

for p4

1468 should it be =a+b+c+d(e+f)(g+h)=([total])<=9>=1

I need to get the sums with roots.

P3 ROOTS          P4 ROOTS

--------------        ---------------

199=19=10=1    1468=19=10=1

Any help with this is very greatly appreciated,  I am dealing with large

numbers from these programs to get down to the roots.

Thanks Alot

NIAN

NIAN

WILLIAMSTOWN,KY
United States
Member #812
October 26, 2002
28 Posts
Offline
 Posted: July 16, 2006, 5:09 pm - IP Logged

P.S.

Is these formulaes correct?

NIAN07

NIAN

New Member
Los Angeles, CA
United States
Member #41864
June 24, 2006
1 Posts
Offline
 Posted: July 16, 2006, 6:11 pm - IP Logged

The formula for finding the digital root of a number x in Microsoft EXCEL program is -

fx = 1 + ( (MOD(x-1) , 9 )

East of Atlanta
United States
Member #6191
August 11, 2004
1390 Posts
Offline
 Posted: July 16, 2006, 6:12 pm - IP Logged

Well, the simple part is FIRST, you must break the numbers into their individual components (Pick 3 is 3 parts, Pick 4 is 4 parts)

This can be done with these 3 formulas
D2 =SUM(1*(LEFT(C2,1)))
E2 =SUM(1*(MID(\$C2,2,1)))
F2 =SUM(1*(MID(\$C2,3,1)))

The (1*) converts the text to a number without fancy data formating. This will only work as a macro, if you are writing VBA, you will have to format the data.
**********************
Then simply add up the data
Group sum is

R2=sum(D2:F2)

The colon is sorta like the "thru" or from D thru F, add this all together

To Reduce this value to the base Sum,
S2=IF(R2=19,1,IF(R2>9,((LEFT(R2,1)*1)+(RIGHT(R2,1)*1)),R2))
*****************************
Pick 4 will look like this
S2=IF((OR(R2=19, R2=28)),1,IF(R2>9,((LEFT(R2,1)*1)+(RIGHT(R2,1)*1)),R2))

I hope this helps.

Sir Metro

WILLIAMSTOWN,KY
United States
Member #812
October 26, 2002
28 Posts
Offline
 Posted: July 16, 2006, 7:03 pm - IP Logged

Hi

Thank you zealot and SirMetro, as you can tell I do not know that much about

writing programs or formulas. But I am going to give it a try. I have put several

of the programs that are on this website together and backing testing them.

So far they are very very good.

I do want to thank everyone that has given of their time and effort on these

programs.

Thanks again
NIAN07

NIAN

 Page 1 of 1