Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need help with IF formula for negative numbers

Topic Labels: Formulas
1486 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Marina_Malazoni
5 - Automation Enthusiast
5 - Automation Enthusiast
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"))
 
 
1 Reply 1
Ben_Young1
11 - Venus
11 - Venus

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"
        )
    )
)