What happens if A1="NO" in the following formula: =IF (A1 = "YES", - ProProfs Discuss
Advertisement

What happens if A1="NO" in the following formula: =IF (A1 = "YES", "DONE", "RESTART")?

What happens if A1="NO" in the following formula: =IF (A1 = "YES", "DONE", "RESTART")?<br/>

Change Image    Delete

Asked by Coulter, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

L. Brett

L. Brett

Ask me anything!

L. Brett
L. Brett, Sales Manager, MBA, Detroit

Answered May 29, 2019

In Excel, it is easy to use this spreadsheet to create specific formulas in specific cells. When you do this, then the information can be added to other cells depending on what you selected to put into these cells. Sometimes, it is not the same information. It may take data from one cell and add or subtract information from it and put it in another cell.

However, you must set the formula in first, or the method won’t work, and the information will not be added to the designated cells. If the following equation is created, A1 = “YES,” “DONE,” “RESTART,” then you may want to know what happens to A1 = “NO.” The formula returns the value “RESTART.”

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Oct 28, 2016

Formula returns the value "RESTART"
upvote downvote
Reply