Help

USE If to create negative #

Topic Labels: Formulas
587 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Veronica_Barema
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
Veronica_Barema
4 - Data Explorer
4 - Data Explorer

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)