if and statement syntax

[#1]

hi i have the following code.

i am trying to do a lookup based on two conditions in the same statement

the first condition provides the correct data, however the second condition does not work.

could you please provide any input for syntax correction.

1.

if(Master_Item.Subassignment= 'x',

Cost_Center_Mapping.Subassignment,

2.

if(Master_Item.Subassignment ='x' ,

and [Bank Code] <> '',

[Bank Code]))

this is for the subassignment field name in the table

[bbi_mba_76]

Hi,

it seems there is a comma before the and.

if(Master_Item.Subassignment ='x' and [Bank Code] <> '',

[Bank Code]))