How to use an IF function in excel.

Question

I need to come up with a formula to make Excel do something for me in a spreadsheet.

I have three columns with a value in the first.

I then need to put a yes or no in the second column.

If the answer is 'yes' I need the third cell in the third column to be the same as the first.

Hope that makes sense and that someone can help me to come up with the correct formula.

Thanks.

Answer 1

For example, A1 contains a number and you want to write "yes" to B1 if the number is negative. Then put this formula to B1: =IF(A1<0,"Yes","No"). Also write this formula to C3: =IF(B1="Yes",A1,"").

Answer 2

Hi @Iona Taylor

Could you please share us with a sample for better analysis?

If the answer is 'yes' I need the third cell in the third column to be the same as the first.

If the answer is 'no' in the second column, what result do you need in the third column?

If it is blank, then please refer to Viorel's suggestion.

Any misunderstandings or updates, welcome to post back.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---