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...
Hi sir,
can you help me with this ifs formula error,
=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")
can you help me with this ifs formula error,
=ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")
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.
- i want this kind of formula.
When time is
>7=LT
<7=P
>19=LT
<19=P
Thanks Sorry, I didn't catch the logic. Let say your time is 10. It's >7 (thus LT), but at the same time it's <19 (thus P). What shall be taken?