If cell = "NO" then move to another cell

S

SAE

If user inputs "NO" to a question, then I want them to insert a comment in
another cell. I cannot figure out how to do this.
 
M

Mike

try this put into column B1 then type no int A1
=IF(A1="NO","then I want them to insert a comment in another cell.","")
 
Top