#UNPARSEABLE for Column "IF" Formula

kss5229

I get an #UNPARSEABLE error for the following formula and am not sure what I'm doing wrong:

=if([Destination]@row] = [Source]@row, [Destination ID #]@row, "")

Where the destination = source, the destination ID should be entered. Otherwise, I want to leave the cell blank so that someone can manually enter the ID #.

kss5229

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:

=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")

Alan P.

Do you have a screenshot of the the column headings, and the field which contains the formula?

kss5229

I just saw the error: an erroneous bracket was after "[Destination]@row" It should be:

=if([Destination]@row = [Source]@row, [Destination ID #]@row, "")