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

A Little Help With Excel Please!!

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

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

Hi

I need to write this in excell, please help.

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

    Avatar
    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

      Avatar
      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 )

       

        SirMetro's avatar - center
        East of Atlanta
        United States
        Member #6191
        August 11, 2004
        1389 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

          Avatar
          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