Multiple IF statements

Barbara Below

I think I have a simple formula containing multiple IF statements but it is coming back as unparseable.

=IF([End Date2]1 = 1, "Sunday", IF([End Date2]1 = 2, "Monday", IF([End Date2]1 = 3, "Tuesday", IF([End Date2]1 = 4, "Wednesday", IF([End Date2]1 = 5, "Thursday", IF ([End Date2]1 = 6, "Friday", IF([End Date2]1 = 7, "Saturday")))))))

What is wrong?

Nic Larsen

You have an extra space in your formula in the Friday IF statement: IF ([End Date2]@row = 6

Nic Larsen

Try:

=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))

Also, the formula should not be in a Date type column. That would have also given you an Unparseable error.

Barbara Below

Thanks for the quick response. Based on your suggestion, I updated the formula to the following:

=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF ([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))

The formula is in a column type "TEXT/NUMBER".

It is still coming back as unparseable.

Nic Larsen

You have an extra space in your formula in the Friday IF statement: IF ([End Date2]@row = 6

Joseph Boyd

=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))

a space between IF ( for row = 6.

Heather Simmons

I am struggling with a multiple if statement....I need to have 8 total. Below is just a start with two. They each work individually (in separate cells) but when I put them together I receive the UNPARSEABLE error. Anyone that can help me get this to work?

=IF(OR([Place in Funnel]2 = "Universe", [Place in Funnel]2 = "Above"), "0%") , (AND([Place in Funnel]2 = "In", [Sales Stage]2 = "Lead"), "10%")

Kelly Moore

Hi Heather

Try this

=IF(OR([Place in Funnel]@row = "Universe", [Place in Funnel]@row = "Above"), "0%", IF(AND([Place in Funnel]@row = "In", [Sales Stage]@row = "Lead"), "10%"))

As written, the cell will be blank if the last clause returns a false. If this isn't what you wanted, insert a

, "whatever is the desired result"

in between the last two parentheses

Connor Uphondo

Im Having trouble making this If Statement work, it Should be when the status row changes Colour then the second status row will change to complete,incomplete, in progress based on the dot colour

=IF ([Status 1]@row = Green, "Complete", IF ([Status 1]@row = Blue ,"In Progress" , IF ([Status 1]@row = Red, "Not Complete", "Blank"

Andrée Starå

Hi @Connor Uphondo

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shubha

Hy Andree,

Could you please help me in fixing this Multiple IF statement :

Explanation:- I am referring Building No. to their respective account manager, What I would like is for the Account manager's name should appear with respect to Building No. But I am continuously getting one error #Unparseable

=IF([Equipment Name]@row<> "",IF(OR(Building@row)=FB1,FB2,LNK,FAB,"Mike Shape",IF([Building@row)=CB1,CB2,GIS,ELY,"Mike Brain",IF(AND(Building@row)=PS1,PS2,BGY," Mike Kitye")))

Genevieve P.

Hi @Shubha

The formula is unable to calculate because of how the OR Functions are set up. You'll need to list out each option within the OR statement, like so:

OR(Building@row = "FB1", Building@row = "FB2", Building@row = "LNK", Building@row = "FAB"), "Mike Shape"

Notice also that any time you're referencing a text string, it should be in quotes (e.g. "LNK")

Try something more like this:

=IF([Equipment Name]@row <> "", IF(OR(Building@row = "FB1", Building@row = "FB2", Building@row = "LNK", Building@row = "FAB"), "Mike Shape", IF(OR([Building@row = "CB1", Building@row = "CB2", Building@row = "GIS", Building@row = "ELY"), "Mike Brain", IF(OR(Building@row = "PS1", Building@row = "PS2", Building@row = "BGY"), "Mike Kitye"))))

Cheers,

Genevieve

Shubha

@Genevieve P.

Thanks for your help. That Worked for me :)