Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract multiple results based on multiple criteria | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Multiple results in 1 cell w/ multiple criteria | Excel Worksheet Functions | |||
Multiple criteria with multiple results in one cell | Excel Worksheet Functions | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) |