Forum Discussion

mmullranin's avatar
mmullranin
Copper Contributor
Feb 24, 2020

need help with a formula

I can not seem to figure how to get the values that I want.   I want to look at a cell with a number. What I am looking to do is look at the number in the cell. is the number in A1 = 200 to 225? th...
Need Help
mmullranin's avatar
mmullranin
Copper Contributor
Feb 24, 2020

John Jairo Vergara Domínguez 

Thanks its almost what im looking for but I need it kinda like if the number in A1 is = to 200 through 225 cell A7=10 but if A1 is  = to 226 through 250 then cell A7= 20 if A1 is = to 251 through 300 A7=30

Twifoo's avatar
Twifoo
Silver Contributor
Feb 25, 2020

mmullranin 

I guess you simply need a sample formula. The figures you cited are just samples. In that case, you may construct your formula with LOOKUP, like this: 

=LOOKUP(A1,

{0,200,226,251,301},

(0,10,20,30,40})

You may modify the values in the foregoing formula to suit your needs. 

  • mmullranin's avatar
    mmullranin
    Copper Contributor
    Feb 26, 2020

    Twifoo  I kinda get your formal but when I try to use it I get an error so I;m doing something wrong. 

     

    I want to look at the GM1,GM2,GM3 and SS rows ans assign a point value based on the score within a range.  Any help would be great.

     

    Thanks

    Matt

     

     

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Feb 26, 2020

      mmullranin 

      I see no formula in your sample file. Where is the error? Please manually enter your expected results.