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?
USE If to create negative #
+2+2I 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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.