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
|