|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 19th, 2009, 01:08 PM
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" 
|
|
#2
May 19th, 2009, 01:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"
|
|
#3
May 19th, 2009, 01:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"
|
|
#4
May 19th, 2009, 01:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"
|
|
#5
May 19th, 2009, 01:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
