| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the If() Function for a percentage range
You're welcome
Tyro "season" wrote in message ... Thank you so much, that works perfectly. Season "Tyro" wrote: If I understand you, and your Percent is in A1 then in A2 put: =LOOKUP(A1,{0,0.06,0.26,0.61},{"None","Not Significant","Signifcant","Severe"}) Tyro "season" wrote in message ... Does anyone know how to set up an equation, i assume using the If funtion but maybe something else to pull from a percentage range. i cannot set it up to work properly since it would have to say greater than a number then less than a number. Example below. % Range Word to list if true 0-5 None 6-25 Not Significant 26-60 Significant 61-100 Severe Thanks so much, Season |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Percentage of True (or False) in a range | Excel Discussion (Misc queries) | |||
| Highlight a cell within a percentage range only? | Excel Discussion (Misc queries) | |||
| Percentage within a range | Excel Worksheet Functions | |||
| Completion Percentage of a date range | Excel Discussion (Misc queries) | |||
| changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
![Tyro[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
