calculet 2 feild

[Anonymous]

hi,

i wrote in the script the next line:

=if(Match([destinetion],'3' and [target],'A'),'123')

but i get nothing in the result.

when i separate it it's o,k.

please help me.

thanks'

[sivarajs · Accepted solution]

Try this

=if(Match(destination,'3' )and Match( [target],'A'),'123')

[#3]

HI

plee see the attachement.

since within match() function we does not take and operator.

and match() function work on selection.

hope this helps you.

=if(Match(destination,'3') and MATCH(target,'A'),'123')