If statement with multiple criteria and multiple results

[Tickfarmer]

I need to create an if statment that considers multiple criteria (CELLS) and
depending on the criteria, returns a different result. For example:

If the originating percentage, in a cell, is between 0 and 79 percent,
return 0% in the column next to the originating percentage. If the
percentage is 80 to 90, return 30%.

Column Column Column
A B C
Low High Reward
0% 79% 0%
80% 90% 30%
91% 99% 50%
100% 100% 100%
101% 125% 125%

However I don't want the percentages in the formula, I want to reference the
cells that the percentages are located in. This is becuase the percentages
change all the time.

Basically I'm taking a percentage and when that percentage falls between one
of the criteria in column a and column B, then return column C.

Example: My originating percentage is 88%, so I need it to return 30% reward.

Any ideas???

 

[Mike H]

Hi,

You don't need column B but it's doing no harm. Try this

=VLOOKUP(H1,A1:C6,3,TRUE)

lookup value in H1

Mike

 

[Bernard Liengme]

Go to Help at read about VLOOKUP
Please come back if you need more help
best wishes

 

[Tickfarmer]

Thanks so much for your quick response. I was making it harder than it had
to be.