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.
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
mmullranin, the same formula
=10*MATCH(A1,{200,225,251})Works with your new range... But, but there are some questions
1. What about numbers before 200?
2. What about numbers after 300?
In all cases, you can add numbers to the matrix constant (first number of range). For example: if you have another range for 40 (for example: 301-350) and for 50 (for example 351 - 410), you can use:
=10*MATCH(A1,{200,225,251,301,351})Blessings!
