I am trying to have a formula that says the following:
1) If the value in this $ field is greater than 0, 'Do this'
2) also, the value in this $ field is 0, 'Do this instead'
3) also, if the value in this $ field is a negative number, 'Definitely do this'.
I have no problem writing formula to address 1 and 2, but I can't figure out how to incorporate condition 3.
Currently, my formula goes as follows (and is missing #3):
IF({Current due after credits}=0, "NO CURRENT DUE",IF({Current due after credits}>0,"CREATE REMIT"))