Use and or in if statement google sheets code example
Example: google sheets if
# Basic syntax:
=IF(condition, outcome_if_true, outcome_if_false)
# Note, the default setup for IF in Google Sheets is an IF ELSE
# Example usage:
=IF(A1 = "this text", "Houston, we have a match", 0)
# This returns "Houston, we have a match" if cell A1 is "this text",
# otherwise, it returns the number 0