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

Excel Help Please

Topic closed. 8 replies. Last post 4 years ago by lottogloria.

Page 1 of 1
PrintE-mailLink
lottogloria's avatar - DiscoBallGlowing
cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
Posted: June 17, 2012, 3:17 pm - IP Logged

LOOKING FOR LMH FORMULA FOR THE 3 AND 4

LOW AS 012
MED AS 3456
HIGH AS 789

THANKS IN ADVANCE
           LG

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: June 22, 2012, 12:24 pm - IP Logged

    What should the formula do?


      United States
      Member #124493
      March 14, 2012
      7023 Posts
      Offline
      Posted: June 22, 2012, 2:16 pm - IP Logged

      LOOKING FOR LMH FORMULA FOR THE 3 AND 4

      LOW AS 012
      MED AS 3456
      HIGH AS 789

      THANKS IN ADVANCE
                 LG

      i guess you could use a countif functions...so countif(range,0)+countif(range,1)+countif(range,2)...and then if you have sum of 3 then it is low...

        lottogloria's avatar - DiscoBallGlowing
        cleveland
        United States
        Member #35045
        March 11, 2006
        40 Posts
        Offline
        Posted: June 23, 2012, 6:01 am - IP Logged

        0,1,2  WOULD GIVE ME THE LETTER  L FOR LOW DIGIT
        3,4,5,6  WOULD GIVE ME THE LETTER M FOR MEDIUM DIGIT
        7,8,9 WOULD GIVE THE LETTER H FOR HIGH DIGIT

        THANKS IN ADVANCE

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: June 23, 2012, 6:15 am - IP Logged

          HINT:

          =IF( when condition , then if true , then if false)

          =if( and(condition, condition), then if true, then if false )
                       

                    ... develop

            lottogloria's avatar - DiscoBallGlowing
            cleveland
            United States
            Member #35045
            March 11, 2006
            40 Posts
            Offline
            Posted: June 23, 2012, 2:56 pm - IP Logged

            THANKS I WILL TRY THIS

            LD

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

              Hi Lottogloria,

              Try this.

              Assuming that your digit is in cell A1.

              =CHOOSE(A1+1, "L", "L", "L","M", "M", "M","M", "H", "H", "H")

              Serge.

                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: June 28, 2012, 8:11 pm - IP Logged

                Public Function LMH(digit) As String
                LMH = WorksheetFunction.Choose(digit + 1, "LOW", "LOW", "LOW", "MED", "MED", "MED", "MED", "HIGH", "HIGH", "HIGH")
                End Function

                LOW AS 012
                MED AS 3456
                HIGH AS 789

                  lottogloria's avatar - DiscoBallGlowing
                  cleveland
                  United States
                  Member #35045
                  March 11, 2006
                  40 Posts
                  Offline
                  Posted: July 3, 2012, 9:21 pm - IP Logged

                  WORKS PERFECT THANKS EVERYONE FOR ALL YOUR HELP

                  LD