Formula issue

Art A

I am using the following formula and getting an #UNPARSEABLE message. I have 3 field conditions that I want to check and set the box to "B" otherwise "S". I Task complete is a checkbox.

=IF(AND([Status] = "Closed", [Change Type] = "BOM Cleanup", [Task Completed] = 1), B, S)

Mark.poole

@Art A

Try this if everything is on the same sheet.

=IF(AND([Status]@row = "Closed", [Change Type]@row = "BOM Cleanup", [Task Completed]@row = 1), B, S)

Mark.poole

@Art A

Try this if everything is on the same sheet.

=IF(AND([Status]@row = "Closed", [Change Type]@row = "BOM Cleanup", [Task Completed]@row = 1), B, S)

Art A

Thanks Mark! I just had to add "" to the B and S at the end and it worked. Still getting use to formula variations.