Skip to main content
Solved

If/Then Formula Help Needed

  • April 7, 2024
  • 2 replies
  • 31 views

Forum|alt.badge.img+6
  • Known Participant

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!

Best answer by AlliAlosa

You’re so close!

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

2 replies

Forum|alt.badge.img+19
  • Inspiring
  • Answer
  • April 7, 2024
You’re so close!

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

Forum|alt.badge.img+6
  • Author
  • Known Participant
  • April 10, 2024

Thank you soo much!