need help with a formula

Question

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? then cell A7=10 if A1 = 226-250 then A7 = 20 and so on.

I'm sure its simple any help would be great.

Thanks

Matt

john jairo vergara domínguez · Answer

mmullranin, you can use this formula (in A7):&nbsp;=10*MATCH(A1,{200,226,251})&nbsp;Blessings!

mmullranin · Answer

John Jairo Vergara Domínguez&nbsp;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&nbsp; = to 226 through 250 then cell A7= 20 if A1 is = to 251 through 300 A7=30

john jairo vergara domínguez · Answer

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

twifoo · Answer

mmullranin&nbsp;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:&nbsp;=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.&nbsp;

mmullranin · Answer

Twifoo&nbsp; I kinda get your formal but when I try to use it I get an error so I;m doing something wrong.&nbsp;&nbsp;I want to look at the GM1,GM2,GM3 and SS rows ans assign a point value based on the score within a range.&nbsp; Any help would be great.&nbsp;ThanksMatt&nbsp;&nbsp;

Forum Discussion

need help with a formula

6 Replies