Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

USE If to create negative #

Topic Labels: Formulas
99 1
Showing results for 
Search instead for 
Did you mean: 

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

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)