Help

Conditional Formula (IF & AND)

Topic Labels: Formulas
1507 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SpookyCheerios
4 - Data Explorer
4 - Data Explorer

I'm trying to set up a formula and could use some help. The first part is simple and is working:

 

IF(
Actuals <= {Approved/Expected Amount},
" On Track",
" Over Budget"
)
 
However I would like it to provide a different result ("Profit") if the Type of record is "Income" vs "Expense" and I'm having difficulty getting that second part to work. Any help is appreciated! 
2 Replies 2

You can use a nested IF statement:

IF({record type} != 'Income',

IF(Actuals <= {Approved/Expected Amount},
"On Track",
"Over Budget"
),

"Profit")



Ben_Young1
11 - Venus
11 - Venus

Hey @SpookyCheerios

Additional details here would be really helpful. The formula you're describing is pretty simple, but it varies depending on the details of what you want to happen if the record type is "Income" or "Expense."

Here's an example.
I just assumed the field used to identify the record type is called "Type", but you can swap it out as needed.
This formula will look at whether the Type field returns the value of "Expense." If that evaluates to true, then it will return the first part of the formula you originally posted.
If the Type field returns a value of "Income", then it will return blank since I don't actually know what you want to happen.
Again, additional details would be greatly appreciated!

 

IF(
    AND(
        {Type},
        {Actuals}
    ),
    SWITCH(
        {Type},
        "Expense",
            IF(
                {Actuals} <= {Approved/Expected Amount},
                "✔ On Track",
                " Over Budget"
            ),
        "Income",
            "Profit"
    ),
    IF(
        {Actuals},
        IF(
            {Actuals} <= {Approved/Expected Amount},
            "✔ On Track",
            " Over Budget"
        )
    )
)