Mutliple operations in the THEN statement of IF condition

[Saratnarendran]

Hi

I would like to write an if condition that has multiple operations to be performed once true. The conditions are as follows:

I have three columns A, B, and C. I need to move values within these 3 columns depending upon null/blank conditions like below:

If A = null and B is not equal to null, THEN

A=B

B=C

C= null

else if A = null and B = null and C is not equal to null, THEN

A = C

B = C = Null

else

[A]

endif

Can someone please advice on how to perform multiple THEN operation?

[EdwardCochrane]

If you are trying to change each field, then you will need three separate formulas, one per column.

e.g.

Formula for A:

If isnull([A] and !isnull([B]) then [B] elseif isnull([A]) and isnull([B]) and !isnull([C]) then [C].

repeat and amend as required for the other two columns.