This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.