Problem with nested IF statements

Kristin N

I'm having a problem with the following statement. Each IF statement works independently, but not when nested. Can't figure out what's wrong.

=IF(AND(Budget1 >= 100000, [Executive Sponsor approval2]1 = "Approved", [Finance Approver approval]1 = "Approved"), "Yes", =IF(AND(Budget1 < 100000, [Executive Sponsor approval]1 = "Approved"), "Yes", "No"))

Andrée Starå

Hi Kristin,

Try removing the = before the second IF.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Kristin N

Thank you! That worked!

Andrée Starå

Excellent!

Happy to help!