Multiple IFs help

Irina Iatco · 01/07/21

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!!

Mark Cronk · 01/07/21

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

Irina Iatco · 01/08/21

https://community.smartsheet.com/discussion/comment/274348#Comment_274348

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. :)

Kelly Moore · 01/07/21

Hi Irina,

The IF(AND( function has the syntax of

IF(AND(criteria #1, criteria #2, etc, last criteria). You use this when multiple conditions must simultaneously be met for the statement to be true. =IF(AND([Indoor/Outdoor]@row="Outdoor", Weather@row="Rainy", Umbrell@row="No"), "I probably got rained on", "I probably stayed dry").

I only see one criteria in each of your AND statements so there is no AND. As written, it reads

If publication@row = "Architectural Record" is true, then fill in the formula cell with url. If publication@row =Architectural Record" is false, move on to the 2nd IF to see if Publication@row = BD+C. If that's true, fill in with that word count phrase. If neither of these are true the cell will be blank

If this is your intention, you can simplify your formula a bit

=IF(Publication@row = "Architectural Record", "https://www.architecturalrecord.com/call4entries/forPublication", IF(Publication@row = "BD+C", "Word count: 500 – 1,200; 4 - 5 images; Media kit: https://web.ingage.io/p/XkUsLBt"))

and you would keep inserting a comma followed by the new IF ahead of the two ending parentheses .

If this isn't your intention, help me understand the combination of criteria you need in your AND statment and we can tweak your formula.

Mark Cronk · 01/07/21

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

Irina Iatco · 01/08/21

https://community.smartsheet.com/discussion/comment/274348#Comment_274348

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. :)

Irina Iatco · 01/08/21

https://community.smartsheet.com/discussion/comment/274349#Comment_274349

Hi, @Mark Cronk

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. :)

Mark Cronk · 01/08/21

Hi Irina,

Happy to help. Glad you found a solution. Thanks for using the Community.

Be Well,

Mark

Multiple IFs help

Best Answers

Answers

Categories