How to use an IF function in excel.

Iona Taylor 0 Reputation points

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.


A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
275 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Viorel 88,236 Reputation points

    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,"").

    1 person found this answer helpful.
    No comments

  2. Emily Hua-MSFT 23,616 Reputation points Microsoft Vendor

    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.