Multiple IFs help
I am trying to create a formula with about 10 if conditions. It works with two, but as I add the 3rd I get an error.
Here's the formula =IF(AND(Publication@row = "Architectural Record"), " https://www.architecturalrecord.com/call4entries/forPublication", IF(AND(Publication@row = "BD+C"), "Word count: 500 – 1,200; 4 - 5 images; Media kit: https://web.ingage.io/p/XkUsLBt"))
Do you know why ?