Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine Value based on criteria
I have a spreadsheet that I need to find a value based on criteria. I have a
dollar amount that a percentage has to be applied to based on 3 different criterias. The criteria may have multiple values to compare. For example, column A has the dollar amount and based on Columns B,C, and D, a certain percetage would be applied to column A. A B C D E $10.00 ACT or TRM <90 or 90 X,Y,Z $10.00*.35=$3.5 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine Value based on criteria
C <90 or 90
Ok, so if C does not equal 90 then it will always be <90 or 90. D X,Y,Z Does that mean D = X or Y or Z? -- Biff Microsoft Excel MVP "Jan S" <Jan wrote in message ... I have a spreadsheet that I need to find a value based on criteria. I have a dollar amount that a percentage has to be applied to based on 3 different criterias. The criteria may have multiple values to compare. For example, column A has the dollar amount and based on Columns B,C, and D, a certain percetage would be applied to column A. A B C D E $10.00 ACT or TRM <90 or 90 X,Y,Z $10.00*.35=$3.5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I determine which sheets meet criteria? | Excel Discussion (Misc queries) | |||
Using Multiple Array Criteria - Determine Average Result | Excel Worksheet Functions | |||
Multiple criteria options determine which name to show as result. | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Determine sums based on value possibilities | Excel Worksheet Functions |