Share via

How to use an IF function in excel.

Iona Taylor 0 Reputation points
2023-02-24T15:47:02.5666667+00:00

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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,830 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 116.6K Reputation points
    2023-02-24T17:58:21.2033333+00:00

    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.
    0 comments
  2. Emily Hua-MSFT 27,636 Reputation points
    2023-02-27T03:03:19.6933333+00:00

    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.

    Capture62

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.