Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If (Or)
Hi
As below I am trying to work out IF stament (OR?) and struggling For example if B"=S then C2 (53) should go in D2 If B2 was IT then C2 (53) should go in E2 If B2 was C then C2(53) should go in F2 Help title S IT C paper S 53 pens S 26.79 computer IT 1300 tea C 3.5 coffee C 5.7 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If (Or)
Hi,
I assume your titles are in row 1 in D2 enter =if($B2=D$1,$C2) Copy the formula to your right and down if this helps please click yes, thanks "k11ngy" wrote: Hi As below I am trying to work out IF stament (OR?) and struggling For example if B"=S then C2 (53) should go in D2 If B2 was IT then C2 (53) should go in E2 If B2 was C then C2(53) should go in F2 Help title S IT C paper S 53 pens S 26.79 computer IT 1300 tea C 3.5 coffee C 5.7 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If (Or)
Thanks so much - it works superb
Regards Steve "Eduardo" wrote: Hi, I assume your titles are in row 1 in D2 enter =if($B2=D$1,$C2) Copy the formula to your right and down if this helps please click yes, thanks "k11ngy" wrote: Hi As below I am trying to work out IF stament (OR?) and struggling For example if B"=S then C2 (53) should go in D2 If B2 was IT then C2 (53) should go in E2 If B2 was C then C2(53) should go in F2 Help title S IT C paper S 53 pens S 26.79 computer IT 1300 tea C 3.5 coffee C 5.7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|