Perform addition with condition in a formula tool

dunkindonut7777

Hi I have a data here that has a field with lacking of figures I want to add digits based on a condition using formula tool. Example below:

Code	Salary
222	10000
333	20000
356	30000

Expected output

Code	Salary
222	12000
333	23000
356	30000

I just want to add some figures if the code is "222" and "333". How can I perform this?

Adriankp

If the amount you want to add is the same for every instance of '222' or '333' a simple IF statement is all that's required.

IF [Code] = '222' THEN

     [Salary] + 2000

ELSEIF [Code] = '333' THEN

     [Salary] + 3000

ELSE [Salary] ENDIF

If I'm misunderstanding what it is you want to do, it would be great if you could provide some more detailed information and I can try to help.