Forum Discussion
help with If formula please
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%
S...
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
Jenine,
=A1*LOOKUP(A1,C11:C15;D11:D15)