jjkh58
New Member
- Joined
- Apr 21, 2021
- Messages
- 8
- Office Version
- 365
- 2013
- 2011
- 2010
- Platform
- Windows
- Mobile
- Web
Hi guys,
Column C
I have something like the above in my spreadsheet. I need to use the formula to tell me whether it's Receiver or Sender, so I used =IF(C1="Receiver","Receiver","Sender") formula to return receiver if the cell contains a word receiver otherwise sender. However, my formula does not work.
Please help me out.
Thanks,
Column C
C1: AS2_Receiver_AdvancedShipmentNotification |
C2: AS2_Sender_AdvancedShipmentNotification |
I have something like the above in my spreadsheet. I need to use the formula to tell me whether it's Receiver or Sender, so I used =IF(C1="Receiver","Receiver","Sender") formula to return receiver if the cell contains a word receiver otherwise sender. However, my formula does not work.
Please help me out.
Thanks,