Help-returning a text value to a corresponding cell

Morayo20

New member
Joined
Aug 30, 2014
Messages
2
Reaction score
0
Points
0
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 :(
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Simply

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

Morayo20

New member
Joined
Aug 30, 2014
Messages
2
Reaction score
0
Points
0
Thank you so much! think I was expecting it to be so much more complicated.
 
Top