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.
Solved! Go to Solution.