Problem with IF-formula?

[NiclasVorre]

Hello smart excelguys ,

My boss told me to make an excelsheet with a little matrix for a exceltabel.

Before I start searching on the internet and renting books, can any of you tell me if this even is possible to do?

I have a table looking like this:

1-20 5
21-30 10
31-50 20

What my boss want me to do is a table if I type in a number in A1 between 1-20 the number in B1 says 5, and if the number in A1 is between 21-30 the number in B1 says 10... And if you hadn't guest the last part here.. If I type in the number between 31-50 it says 20.

Is it even possible to make an fomular that do this?

[twiggywales]

there are several ways to do it to be honest.

I personally do it this way

one possiblilty.xlsx

[twiggywales]

if you wanted to do this with if you could do it like this

Please Login or Register  to view this content.

[twiggywales]

or if like me you dont like nested ifs as they get silly confusing you could try this

Please Login or Register  to view this content.

more.xlsx

this shows more ways.

(there are even more ways as well. which you use depends on what your using the data for and how complicated the info can be)

[NiclasVorre]

So far all of them are pretty good for what I need to use it for.

Thak you so much!

This site is awesome.. And I'll start looking around and see if there are other interesting thing I can impress my boss with!

[twiggywales]

gald to help,

remember to mark it solved and a star tap to anyone that helps is always appreciated

[NiclasVorre]

Did you get my star?