Help

If/Then Formula Help Needed

Topic Labels: Formulas
Solved
Jump to Solution
299 2
cancel
Showing results for 
Search instead for 
Did you mean: 
TRBS
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I need help with my formula.

If <total amount paid> is not blank, then the cell becomes <ACT Planner>. However if <total amount paid> is blank, then cell becomes <EST Planner>.

I got this far, but can't get the 2nd part to work:

IF(
{Total Amount Paid},
{ACT Planner}
)
 
Thank you!
1 Solution

Accepted Solutions
AlliAlosa
10 - Mercury
10 - Mercury
You’re so close!

IF
(
    {Total Amount Paid},
    {ACT Planner},
    {EST Planner}
)

See Solution in Thread

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury
You’re so close!

IF
(
    {Total Amount Paid},
    {ACT Planner},
    {EST Planner}
)
TRBS
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you soo much!