I know that we can use the AND function to create conditions based off of more than one criteria:
=IF(AND(A2<>"", B2=""), "You are missing a last name", "")
However, in SQL and programming we can specify AND with
&& and OR with
||. This makes expressions easier to parse, especially when you have a bunch of conditions chained together:
=IF(A2<>"" && B2="", "You are missing a last name", "")
When I try the above, it shows the error:
Formula parse error.
Is there a symbol we can use for AND and OR instead of the functions in Google Sheets?
The reason I suspect there might be a symbol is because instead of
CONCATENATE, they allow you to use the
=CONCATENATE(A2, B2, C2)
Is the same as:
=A2 & B2 & C2
Thus I suspect there might be a succinct way to specify AND and OR conditions.