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 ?


Thanks!!

Tags:

Best Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Hi @Irina Iatco ,

    I'm having a problem teasing apart your formula and your AND statements.

    To nest IF statement you have to continue the Syntax: =IF(Β logical_expression1,Β value_if_true,Β IF(logical_expression2,Β value_if_true, IF(logical_expression3,Β value_if_true, IF(logical_expression4,Β value_if_true, IF(logical_expression5,Β value_if_true, IF(......... , [Β value_if_falseΒ ])))))

    At the end of the statement there wil be a ")" for every IF.

    I don't think you need the ANDs. Try: =IF(Publication@rowΒ = "Architectural Record", "Β https://www.architecturalrecord.com/call4entries/forPublication",Β IF(logical_expression3,Β value_if_true, IF(logical_expression4,Β value_if_true, IF(logical_expression5,Β value_if_true, IF(......... , [Β value_if_falseΒ ])))))

    Any help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Irina Iatco
    Irina Iatco ✭✭
    Answer βœ“

    Thank you so much! It worked. I only added the "and" because I copied the formula from somewhere else and I wasn't sure what it's for. :)

Answers