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.
i want this kind of formula.
When time is
>7=LT
<7=P
>19=LT
<19=P
Thanks
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?