This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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?
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}=“E...
