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...
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.
