| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements
Ok, here's one that has me stumped and hoping someone can help. Let me see
if I can explain what I am trying to do. I have two conditions in cells C8 & H8, both are numeric values. I8 will show a text value with the result of the first two conditions. My problem is that this is a really large formula because cell G8 is a range between 0 and 6 and H8 is a percentage. For example... G8 H8 I8 0-1 30-40% Successful 1-2 40-50% Successful 2-3 50-60% Successful 3-4 60-70% Successful 4-5 70-80% Successful 5-6 80-90% Successful 6+ <80% Does Not Meet 80-89% Inconsistent 90-114% Successful Etc. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statements | Excel Worksheet Functions | |||
| If, then statements | Excel Discussion (Misc queries) | |||
| If then statements | Excel Discussion (Misc queries) | |||
| If And statements -- HELP! | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
Threaded Mode
