| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If logic for text
Hi,
I am creating a defect log in which i am trying to capture the severity of the defect based on its type. I have about 18 types of defect. What i want now is if the user selects 1-10 defects, the defect severity should be High and from 11-15, it has to be medium and from 16-18, it has to be low. Can some one help me with this formula please? Please note that this has to look at a cell with TEXT and not a value. Regards, Sri Harsha. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF for multiple text data creating a logic statment | Excel Worksheet Functions | |||
| I Then logic help | Excel Worksheet Functions | |||
| Can an Excel logic function change the color of a cell or text? | Excel Worksheet Functions | |||
| IRR Logic | Excel Worksheet Functions | |||
| IF THEN LOGIC | Excel Discussion (Misc queries) | |||
Threaded Mode
