| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More if then logic
Here's another one for ya--
I'm creating a calculator that returns a value based on rankings. Values 1-6 should return X value, values 7-12 return Y value, values 13-22 should return Z value. X, Y and Z represent 100% of max, 50% of max and 0% of max respectively. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More if then logic
Try the below
=LOOKUP(A1,{0,1,7,13,23},{"","X","Y","Z",""}) If this post helps click Yes --------------- Jacob Skaria "DJ" wrote: Here's another one for ya-- I'm creating a calculator that returns a value based on rankings. Values 1-6 should return X value, values 7-12 return Y value, values 13-22 should return Z value. X, Y and Z represent 100% of max, 50% of max and 0% of max respectively. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More if then logic
Missed to mention to add your rankformula to the below..formula
=LOOKUP(yourRankformulahere,{0,1,7,13,23},{"","X", "Y","Z",""}) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =LOOKUP(A1,{0,1,7,13,23},{"","X","Y","Z",""}) If this post helps click Yes --------------- Jacob Skaria "DJ" wrote: Here's another one for ya-- I'm creating a calculator that returns a value based on rankings. Values 1-6 should return X value, values 7-12 return Y value, values 13-22 should return Z value. X, Y and Z represent 100% of max, 50% of max and 0% of max respectively. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOGIC | Excel Discussion (Misc queries) | |||
| I Then logic help | Excel Worksheet Functions | |||
| Logic please | Excel Discussion (Misc queries) | |||
| If Then logic not enough | Excel Discussion (Misc queries) | |||
| IRR Logic | Excel Worksheet Functions | |||
Linear Mode
