Welcome Guest
Log In | Register )
You last visited May 21, 2018, 12:40 am
All times shown are
Eastern Time (GMT-5:00)

Excel formula needed

Topic closed. 6 replies. Last post 13 years ago by SirMetro.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Thread Starter
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: April 6, 2005, 12:35 pm - IP Logged

Does anyone have a formula that would label numbers 0 thru 4 as low & 5 thru 9 as high?

Suggestions would be greatly appreciated. 

 

L ttaL   T

    SirMetro's avatar - center
    East of Atlanta
    United States
    Member #6191
    August 11, 2004
    1390 Posts
    Offline
    Posted: April 6, 2005, 12:58 pm - IP Logged

    I think such a formula would go as such:

    Cell A1, B1 & C1 has numbers 456 respectively, the formula for position 1 would be

    =if(A1>5,"L","H")  'or you could have the world Low/High spelled out, your choice.

    =if(B1>5,"L","H")

    =if(C1>5,"L","H")

    Keep in mind this info would need to exist within a group of cells by itself so you could track it easier.

    Sir Metro

      Sandy K's avatar - graphic pub.jpg
      Clarkston, Michigan
      United States
      Member #76
      January 6, 2002
      8528 Posts
      Offline
      Posted: April 6, 2005, 1:30 pm - IP Logged

      =IF(A1>4,"H","L") goes under each cell.....D1,E1,F1, then you need to do it all over again for E1 with the formula stating B1 (instead of the A1).....then go to F1 and insert the above formula substituting the C1 for the A1 in the E1 cell.

                                formula gets inserted here:

      A1, B1, C1          D1    E1    F1 

      8    6    0

      The formula I have treats a zero as a low number.....I believe Sir Metro's formula above treats the zero as a high number.............just a matter of how you interpret it................

        SirMetro's avatar - center
        East of Atlanta
        United States
        Member #6191
        August 11, 2004
        1390 Posts
        Offline
        Posted: April 6, 2005, 2:08 pm - IP Logged

        Sandy,

        I think the wording of my formula looks to see if the value referenced is less then 5, not equal to, but less then. Anything less then 5 will be considered Low. Your formula will look to see if the value is less then 4, putting 4 into the High category.

        Sir Metro

          SirMetro's avatar - center
          East of Atlanta
          United States
          Member #6191
          August 11, 2004
          1390 Posts
          Offline
          Posted: April 6, 2005, 2:29 pm - IP Logged

          ah....I see what I did wrong...I got the direction of the arrow wrong...my bad...sorry Sandy, you are correct, the ">" means greater then and "<" means less then and I had it backwards.

            lottaloot's avatar - AvatarZ56
            Thread Starter
            Redford/MI
            United States
            Member #3396
            January 18, 2004
            4867 Posts
            Offline
            Posted: April 6, 2005, 3:13 pm - IP Logged

            Thanks All. 

            SirMetro, I did not want to pm you yet again but I am glad that you had pity on me yet again

            I am learning so much from you guys. 

            L ttaL   T

              SirMetro's avatar - center
              East of Atlanta
              United States
              Member #6191
              August 11, 2004
              1390 Posts
              Offline
              Posted: April 6, 2005, 3:22 pm - IP Logged

              Lottaloot, You are welcomed to ask me anything anytime. If I know the answer, I would be glad to share it with you. If not, I will advise accordingly. And it doesn't hurt to do open forum either cause, thanks to Sandy, she noticed I had the <operator> backwards. And somebody else may have an easier and smarter way of solving the problem.

              Sir Metro

              PS: As for pity, my wife would be first to tell you, I don't do pity very well.