Formula to return text
Closed
stever
-
Nov 18, 2022 at 10:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2022 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 21, 2022 at 12:03 PM
Related:
- Formula to return text
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 18, 2022 at 03:55 PM
Nov 18, 2022 at 03:55 PM
stever, Good afternoon.
If that data 7am, 3pm or 11pm are real time and not typed texts, a simple formula with IF function solves your need.
Do you have periods of hours that these messages should appear?
Hope hear form you soon.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 21, 2022 at 12:03 PM
Nov 21, 2022 at 12:03 PM
Hi Stever,
You are looking for a so called nested IF formula:
=IF(A2="7am","Days",IF(A2="3pm","Afternoon",IF(A2="11pm","Midnights","")))
Best regards,
Trowa