Multiple IF functions within one equation?
I am trying to use multiple IF functions within one equation and getting an unparseable error!
This function should return differently if a program is U12 type "Active", if it is not "Active", is "Virtual" and not "Youth and Adult", if it is "Virtual" and "Youth and Adult" and if otherwise (not youth and adult, not virtual and not type "Active")
The equation shows up in full colour when I put it into a cell, so the basic syntax is there, but I can't figure out why it isn't working. Are my parantheses in the right place?
=IF([U12 In-Person Program Type]@row = "Active", ([Facility Name]@row+" "+"Active/Multisport" + " " +[Program Day of Week]@row +" " + [Season]@row),(IF(AND([Virtual]@row=true, [Youth & Adult Program]@row=false),[Virtual Program Type]@row + " Virtual Program" + [Program Day of Week]@row + " " + [Season]@row),(IF(AND([Virtual]@row=true,[Youth & Adult Program]@row=true),"N/A",([Facility Name]@row + " " + [U12 In-Person Program Type]@row + " " + [Program Day of Week]@row +" " + [Season]@row)))))
Answers
-
=IF([U12 In-Person Program Type]@row = "Active", [Facility Name]@row+" "+"Active/Multisport" + " " +[Program Day of Week]@row +" " + [Season]@row, IF(AND([Virtual]@row=true, [Youth & Adult Program]@row=false), [Virtual Program Type]@row + " Virtual Program" + [Program Day of Week]@row + " " + [Season]@row, IF(AND([Virtual]@row=true, [Youth & Adult Program]@row=true),"N/A", [Facility Name]@row + " " + [U12 In-Person Program Type]@row + " " + [Program Day of Week]@row +" " + [Season]@row
I think these changes may work for you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!