If a column contains one value, then convert the amount in a different column to a negatie

[dberroth]

So I have two columns, one column has values 1-5 named "Type". The second column is named "Dolllars" and has dollar amounts. I need to have a statement that IF column "Type" has a value of 2, then the dollar amount in the same row in "Dollars" column should convert to negative. 

I hope I explained what I'm trying to do good enough. Is this a formula function I assume? I'm not having luck getting this resolved.

Any direction is appreciated.

[jrgo · Accepted solution]

@dberroth 

Try

IF [Type] = '2'
THEN [Dollar] * -1
ELSE [Dollar]
ENDIF