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"

IF Statment more than 7 stacked ?
 

Hi,
Insert a column just beside column B and enter a list of all your letters
starting in C2 then in the cell where you want the formula enter

=sumproduct(--(e14=$c$2:$c$28),($F$14+($F$14*B2:B28)))

If this was helpful please click yes, thanks
"keeny" wrote:

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"

IF Statment more than 7 stacked ?
 

=IF(OR(CODE(E14)<CODE("A"),CODE(E14)CODE("Z")),"r esult
undefined",F14*(1+OFFSET($B$2,CODE(E14)-CODE("A"),0)))
--
David Biddulph

"keeny" wrote in message
...
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"

IF Statment more than 7 stacked ?
 

No IF's are needed:

=F14+F14*INDIRECT("B" & (CODE(E14)-63))

--
Gary''s Student - gsnu200853


"keeny" wrote:

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"

IF Statment more than 7 stacked ?
 

.... or =IF(OR(CODE(UPPER(E14))<CODE("A"),CODE(UPPER(E14)) CODE("Z")),"result
undefined",F14*(1+OFFSET($B$2,CODE(UPPER(E14))-CODE("A"),0))) if you want to
allow for lower-case inputs.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(OR(CODE(E14)<CODE("A"),CODE(E14)CODE("Z")),"r esult
undefined",F14*(1+OFFSET($B$2,CODE(E14)-CODE("A"),0)))
--
David Biddulph

"keeny" wrote in message
...
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"