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