Unparseable If statement

L. Barrett

This is not a hard situation but I have tried to fix it may times without success. I am thinking there is a parentheses in the wrong spot.

=IF([Number of Meeting Days]@row = 3, ([Meeting Date 1]@row + " - " + [Meeting Date 3]@row), (IF([Number of Meeting Days]@row = 2, ([Meeting Date 1]@row + " - " + [Meeting Date 2]@row), IF([Number of Meeting Days]@row = 1, [Meeting Date 1]@row)) "Number of Days Value is Missing"))

Thanks!

Paul Newcome

Try this:

=IF([Number of Meeting Days]@row = 3, [Meeting Date 1]@row + " - " + [Meeting Date 3]@row, IF([Number of Meeting Days]@row = 2, [Meeting Date 1]@row + " - " + [Meeting Date 2]@row, IF([Number of Meeting Days]@row = 1, [Meeting Date 1]@row, "Number of Days Value is Missing")))

Paul Newcome

Try this:

=IF([Number of Meeting Days]@row = 3, [Meeting Date 1]@row + " - " + [Meeting Date 3]@row, IF([Number of Meeting Days]@row = 2, [Meeting Date 1]@row + " - " + [Meeting Date 2]@row, IF([Number of Meeting Days]@row = 1, [Meeting Date 1]@row, "Number of Days Value is Missing")))

L. Barrett

@Paul Newcome Thanks. Worked perfectly!

Paul Newcome

Happy to help. 👍️