Straight table question

[Annapurna1]

Hi Team,

Here is my requirement..

If i have 3 Columns then if Col(1)>0 ,Col(2)=0 and Col(3)>0 then my Last column should be  TW/HL

in the same way

If i have 3 Columns then if Col(1)=0 ,Col(2)>0 and Col(3)=0 then my Last column should be  FM

Its an urgent requirement can you please help me out with this asap.

[Vegar]

Try an IF(IF)) statement. 

IF(Column(1)>0 and Column(2)=0 and Column(3)>0, 'TW/HL', IF( Column(1)=0 and Column(2)>0 and Column(3)=0, 'FM', NULL() ))

[Annapurna1]

TW		Farm		Farm Digital		HL		CL
Count	Value in CR	Count	Value in CR	Count	Value in CR	Count	Value in CR	Count	Value in CR	Product
										FM
										TW/FM
										TW/FM/HL
										TW/HL

[Annapurna1]

No, the requirement is...if Count of TW is >0 the product column should be TW, if count of  TW and FM > 0 then product column should be TW/FM, in the same way if Count of all TW FM HL and CL > 0, then product column should be TW/FM/HL/CL

Please help me out as its urgent requirement..