| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a shorter # of Levels
I have Excel 2000 so these problems are more than 7 levels is there a way to
make them shorter. I did make a vlookup for them but if I have to move the cell then I have to re-reference that vlookup so I figured a formula would be easier if it is possible. Thank you for any help that you can provide. =IF(E4="",0,IF((E4="F"),8,IF((E4="D"),4,IF((E4="T" ),2,IF((E4="S"),1,IF( (E4="M"),0,IF((E4="L"),-1,IF((E4="H"),-2,IF((E4="G"),-4,IF((E4="C"),-8,"ERR")) )))))))) =IF(E4="",0,IF((E4="F"),8,IF((E4="D"),4,IF((E4="T" ),2,IF((E4="S"),1,IF( (E4="M"),0,IF((E4="L"),1,IF((E4="H"),2,IF((E4="G") ,4,IF((E4="C"),8,"ERR")))))) )))) -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorter way | Excel Discussion (Misc queries) | |||
| Macro name shorter | Excel Discussion (Misc queries) | |||
| Is there a shorter/quicker way to do this? | Excel Worksheet Functions | |||
| iso shorter equation | Excel Discussion (Misc queries) | |||
| shorter macro | New Users to Excel | |||
Threaded Mode
