IF Formula Question

[Cferrer6]

Hi all,

I am new to Alteryx. Does anyone know how to complete an If formula for below? 

Attached Photo shows my report. IF the number is negative (or less than 0) then i want to multiple it by -1 to make it positive AND i want to change the rmk from 63 to 13. Any suggestions?

[echuong1 · Accepted solution]

Both of these can be accomplished with a conditional statement in a formula.

I started by updating the Rmk field. I created a statement to say if AR <0 then change it to 13, otherwise leave it as is. I then used a similar formula to multiple AR by -1 if negative.

[Cferrer6 · Accepted solution]

It worked perfectly! Thank you so much