Formula to return text
stever
-
Nov 18, 2022 at 10:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 21, 2022 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 21, 2022 at 12:03 PM
Related:
- Formula to return text
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Flipkart return comments - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- If cell contains date then return value ✓ - Office Software Forum
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.
Belo Horizonte, MG - Brasil.
Marcílio Lobão
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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
