If statement with multiple criteria and multiple results
 

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

If statement with multiple criteria and multiple results
 

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

"Tickfarmer" wrote:

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

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

If statement with multiple criteria and multiple results
 

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


"Mike H" wrote:

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

"Tickfarmer" wrote:

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