Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

This works in LibreOffice.

=AND($C10="Combining two cases",'FNL LIMIT'.$C9="")

Either the issue is ! or the smart quotes in the formula you pasted.

This works in LibreOffice.

=AND($C10="Combining two cases",'FNL LIMIT'.$C9="")

Either the issue is ! or the smart quotes in the formula you pasted.posted.

This works in LibreOffice.

=AND($C10="Combining two cases",'FNL LIMIT'.$C9="")

Either the issue is ! or the smart quotes ( and ) in the formula you posted.

This works in LibreOffice.

=AND($C10="Combining two cases",'FNL LIMIT'.$C9="")

Either the issue is The formula you posted has! or the and smart quotes ( and ) in the formula you posted.instead.