View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default If statement with multiple criteria and multiple results

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