ifs google sheets example

Example 1: 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

Example 2: google sheets conditional formatting custom formula current cell

The current cell is addressed by the first cell of a range in the conditional formatting. In your example, the range is A4:M10 and therefore you can use A4 as "current cell".

Check for empty content:
=A4=""