I’ve seen other conversations on the community forums about multiple IF statements, and have set out the formula correctly (99% sure anyway) but it still shows up as incorrect formula.
All of my syntax is correct.
Is there a limit to number of statements within a formula?
Can AND not be use to produce numeric values?
Anything else I’m missing?
IF(AND({PRODUCTION TYPE}= “Panel Discuss”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),1200,
IF(AND({PRODUCTION TYPE}= “Live Broadcast Event”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),3000,
IF(AND({PRODUCTION TYPE}= “Pre-Recorded Webinar”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),1500,
IF(AND({PRODUCTION TYPE}= “Voice Over”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),200,
IF(AND({PRODUCTION TYPE}= “Podcast”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),200,
IF(AND({PRODUCTION TYPE}= “Dialogue/Fireside Chat”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),1000,
IF(AND({PRODUCTION TYPE}= “Green Screen”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),800,
IF(AND({PRODUCTION TYPE}= “Photography”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),400,
IF(AND({PRODUCTION TYPE}= “Event Videography”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),850,
IF(AND({PRODUCTION TYPE}= “Voiceover + Motion Graphics”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),1200,
IF(AND({PRODUCTION TYPE}= “Animation & Motion Graphics”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),1500,
IF(AND({PRODUCTION TYPE}= “Edit Only”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),750,
IF(AND({PRODUCTION TYPE}= “Talking Head”,{EDITING INTERNAL OR EXTERNAL}= “INTERNAL”),400,0)))))))))))))