Thread: A formula to understand range and apply criteria

I have a question and I really dont know how to solve it.I am looking at ranges and applying different criteria to degrees.

I am looking at angles within a 360 degree circle.
For those angles that fall say, between:
360-351 - Apply a factor of 1.9
350-341 - Apply a factor of 1.78
340-321 - Apply a factor of 1.6

etc.

Now, I am given a band that spreads across multiple factors. Say the band is 355-348.
For this example,
355, 354, 353, 352, 351 all need to be multiplied by 1.9.
350, 349 and 348 need to be multiplied by 1.78.

So the results should look like I have (5x1.9) + (4x1.78).

I can create a lookup table that has every angle and the appropriate factor but how do I automate this?? I know, left field but I spend so much manual effort and would love to automate it. I think if statements and lookups might work but any suggestions on this would be great

have a look at the attached and let me know if it helps.

Hi,

an example: write a table in A1:B3

A1=321 A2=341 A3=351
B1=1.6 B2=1.78 B3=1.9

to get the factor

=VLOOKUP(your number,$A$1:$B$3,2,1)

Hope it helps

Hey thanks so much for the quick response. Sofistikat, how did you work that out. That does exactly what I want it to do. Thanks everyone!

You're just very good at explaining things ;-)

Would you mind marking this thread solved please?