Forum Discussion
Aaron Fitzgerald
Nov 15, 2017Copper Contributor
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...
Wipsupervisor
Oct 15, 2020Copper Contributor
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
SergeiBaklan
Oct 15, 2020Diamond Contributor
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?