Results 1 to 3 of 3

Thread: Help-returning a text value to a corresponding cell

  1. #1

    Help-returning a text value to a corresponding cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, guys I need some help please. I did a triage of some products and gave some recommendations. Not everyone accepted and now I need a formula to calculate new results. I have tried if formula but its not working. e.g:
    column a. column b. column c
    go. accept
    stop accept
    start. decline
    go. accept
    go. decline

    column a is my advice, column b is their response. In column c I would like the result (text) of column a if in column b it has been accepted. And if its not accepted for column c to display what is in column b. Any help would be much appreciated. Hope I explained it well

  2. #2
    Simply

    =IF(B2=accept",A2,B2)

  3. #3
    Thank you so much! think I was expecting it to be so much more complicated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •