Forum Discussion
IFS function not working
Hello, I recently brought a spreadsheet over to a new laptop and the IFS statements that I had been using are no longer recognized. I get the #NAME? error in all cells that are currently using th...
Support page https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45 says it's for Office 365 subscribers
Hi Sir,
can you help me with this ifs error
=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")
| #NAME? | |||
| 01-Oct | 02-Oct | 03-Oct | |
| Restday | Thursday | Friday | Saturday |
| Monday | 6:14 | 6:12 | 6:39 |
Thanks
