| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statment more than 7 stacked ?
Hi I am trying to completed this statment up to "Z"
Whats the best way to do this ? Excel 2003 =IF(E14="A",F14+(F14*$B$2),IF(E14="B",F14+(F14*$B$ 3),IF(E14="C",F14+(F14*$B$4),IF(E14="D",F14+(F14*$ B$5),IF(E14="E",F14+(F14*$B$6),IF(E14="F",F14+(F14 *$B$7),IF(E14="G",F14+(F14*$B$8),IF(E14="H",F14+(F 14*$B$9))))))))) As you can see im stuck at "H" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statment help | Excel Worksheet Functions | |||
| Can I get multiple stacked bars per entry on a stacked bar chart? | Excel Discussion (Misc queries) | |||
| ?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
Threaded Mode
