| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If value matches criteria, return formula
I'm creating a calculator that returns a value based on a set of criteria.
One example: scores below 0% should return X value, between 0-10% should return Y value, scores greater than 10% should return Z value. X, Y and Z represent 0% of max, 50% of max and 150% of max respectively. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value of non matches in columns | Excel Discussion (Misc queries) | |||
| i need to get all matches in one column for one criteria | Excel Worksheet Functions | |||
| Is there any way to use HLOOKUP in an array formula to return multiple matches? | Excel Worksheet Functions | |||
| How do I use lookup to return multiple matches and sum them? | Excel Discussion (Misc queries) | |||
| Vlookup to return the sum of multiple matches | Excel Discussion (Misc queries) | |||
Threaded Mode
