USE If to create negative #

[Veronica_Barema]

I am creating an income/expense log - I would like the currency amount to automatically become a negative number when the single select option is “expense.”

Can I use IF to make this happen?

[Veronica_Barema]

I solved my own problem. For those interested… Here’s the formula I used to create a second field that automatically turns the currency amount to negative when “expense” is chosen in the single select income/expense field:
IF({Income or Expense}=“Expense”, {Amount} * -1)