Go to Help at read about VLOOKUP
Please come back if you need more help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Tickfarmer" wrote in message
...
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???
--
Tickfarmer