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...
That could be
=IFS( (BG8>7/24)*(BG8<19/24),"LT",TRUE,"P")
or
=IF( (BG8>=7/24)*(BG8<=19/24),"LT","P")
In Excel datetime is actually the number their date is integer part and time is decimal one. In days calculation one day is equal to 1, thus one hour is 1/24.
Thanks for your response,
but seems the formula was not meet the condition
| 15:00 | |||||||||
| #NAME? | =_xlfn.IFS( (BG8>7/24)*(BG8<19/24),"LT",TRUE,"P") | ||||||||
| LT | =IF( (BG8>=7/24)*(BG8<=19/24),"LT","P") | ||||||||
- I think IFs is not supported on my excel work sheet
Yes, it's not supported. For such case simple IF() is even easier.