In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
Tap an option to check yourself.
Answer: A) The formula returns the text "RESTART".
Since A1 is not "YES", IF returns the value_if_false argument, which is "RESTART".
Source: Scan #46 page 6 Q381