help with If formula please

[Jenine Montalbano]

Hello

Trying to insert a function that will look at ranges of numbers in 5 cells and return an answer of Cell1 * Cell 2:

Ex

1 - 10      20%

11-20      30%

21-30      40%

So if cell 1A equals 8, I want to return a simple answer that multiplies one cell by another.

[#2]

Probably should have been more clear:

Example:

1 - 10     20%

11-20     30%

21-30     40%

31-40     50%

41-50     60%

I am trying to write formula that says look at Cell A1, find which range A1 falls into, then multiply Cell A1 by the % above

thanks in advance

[#3]

Jenine,

=A1*LOOKUP(A1,C11:C15;D11:D15)