If/Then Formula Help
Solved/Closed
MrJags
Posts
2
Registration date
Friday 16 December 2016
Status
Member
Last seen
16 December 2016
-
16 Dec 2016 à 13:01
MrJags Posts 2 Registration date Friday 16 December 2016 Status Member Last seen 16 December 2016 - 16 Dec 2016 à 13:33
MrJags Posts 2 Registration date Friday 16 December 2016 Status Member Last seen 16 December 2016 - 16 Dec 2016 à 13:33
Related:
- Formula for
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Moderator
Last seen
30 September 2021
149
16 Dec 2016 à 13:12
16 Dec 2016 à 13:12
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)
16 Dec 2016 à 13:33
Thanks BrianGreen!