View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
keeny keeny is offline
external usenet poster
 
Posts: 2
Default 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"