
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 24, 2023 08:57 AM
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"))
Reply
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 24, 2023 09:51 AM
Here you go:
IF(
{Current due after credits} < 0,
"Your Desired Return Value",
IF(
{Current due after credits} = 0,
"NO CURRENT DUE",
IF(
{Current due after credits} > 0,
"CREATE REMIT"
)
)
)
