| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If value matches criteria, return formula
X, Y and Z represent 0% of max, 50% of max
and 150% of max respectively Max of what? Let's assume "max" is 100. =IF(COUNT(A1),IF(A1<0,0,IF(A1<=10%,100*0.5,100*1.5 )),"") -- Biff Microsoft Excel MVP "DJ" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If value matches criteria, return formula
Worked like a charm, you're the best!
"T. Valko" wrote: X, Y and Z represent 0% of max, 50% of max and 150% of max respectively Max of what? Let's assume "max" is 100. =IF(COUNT(A1),IF(A1<0,0,IF(A1<=10%,100*0.5,100*1.5 )),"") -- Biff Microsoft Excel MVP "DJ" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If value matches criteria, return formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "DJ" wrote in message ... Worked like a charm, you're the best! "T. Valko" wrote: X, Y and Z represent 0% of max, 50% of max and 150% of max respectively Max of what? Let's assume "max" is 100. =IF(COUNT(A1),IF(A1<0,0,IF(A1<=10%,100*0.5,100*1.5 )),"") -- Biff Microsoft Excel MVP "DJ" wrote in message ... 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? |
| Reply |
| 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) | |||
Linear Mode
