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

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

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