If (Or)

[k11ngy]

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

 

[Eduardo]

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]

Thanks so much - it works superb

Regards

Steve

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