Forum Discussion
need help with a formula
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
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.
- mmullraninFeb 26, 2020Copper Contributor
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
- TwifooFeb 26, 2020Silver Contributor
I see no formula in your sample file. Where is the error? Please manually enter your expected results.