If/Then Formula Help
Solved/Closed
MrJags
Posts
2
Registration date
Friday December 16, 2016
Status
Member
Last seen
December 16, 2016
-
Dec 16, 2016 at 01:01 PM
MrJags Posts 2 Registration date Friday December 16, 2016 Status Member Last seen December 16, 2016 - Dec 16, 2016 at 01:33 PM
MrJags Posts 2 Registration date Friday December 16, 2016 Status Member Last seen December 16, 2016 - Dec 16, 2016 at 01:33 PM
Related:
- If/Then Formula Help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Updated by BrianGreen on 16/12/16 at 01:14 PM
Updated by BrianGreen on 16/12/16 at 01:14 PM
Hi MrJags,
Im not an excel guru and I cant test this as I dont have excel installed on my pc here in the office,but here is what I would try. Im not sure if it is the best or most efficient way, but I would use the if/else statement. Something like ...
=if(G5:G13="Gerald Martin","SEND","")
Explenation ... if G5:G13 = "Gerald Martin", then "send" is printed (that stated after the first comma, else i(if G5:G13 is not "Gerald Martin) nothing is printed (that stated after the second comma).
Please let me know if it works.
I really appreciate thank you messages as a payment for solving issues :o)
Im not an excel guru and I cant test this as I dont have excel installed on my pc here in the office,but here is what I would try. Im not sure if it is the best or most efficient way, but I would use the if/else statement. Something like ...
=if(G5:G13="Gerald Martin","SEND","")
Explenation ... if G5:G13 = "Gerald Martin", then "send" is printed (that stated after the first comma, else i(if G5:G13 is not "Gerald Martin) nothing is printed (that stated after the second comma).
Please let me know if it works.
I really appreciate thank you messages as a payment for solving issues :o)
Dec 16, 2016 at 01:33 PM
Thanks BrianGreen!