I would like to populate a column R with the value YES, if another column N has a value of NO.
The syntax for the IF function is:
=IF ( test, then_true, otherwise_value ).
In order to populate an entire column, you must use the
IF function in combination with an
ARRAYFORMULA. Add the following formula in
It says, that if column N has an entry named "NO", then add "YES" in the corresponding R column. If the above criterion isn't met, then show nothing (""). The
ARRAYFORMULA will make it possible to use a complete column range.
I've prepared an example file for you: using IF