Forum Discussion

Aaron Fitzgerald's avatar
Aaron Fitzgerald
Copper Contributor
Nov 15, 2017

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...
Excel Desktop
Formulas & Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 29, 2018

In general shall work

Perhaps some other reason. If you attach sample file we may check if it works on other platform.

ApolloJFK's avatar
ApolloJFK
Copper Contributor
Jul 26, 2019

IFS does not work in my Excel 2016 even though the help page says it does.  It is not listed in the functions.

    • Wipsupervisor's avatar
      Wipsupervisor
      Copper Contributor
      Oct 15, 2020
      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")
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 15, 2020

        Wipsupervisor 

        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.

    • Wipsupervisor's avatar
      Wipsupervisor
      Copper Contributor
      Oct 15, 2020

      SergeiBaklan 

       

      Hi Sir,

      can you help me with this ifs error

       

      =ifs(BG8>"7:00","LT",BG8>"19:00","LT",BG8<"7:00","P",BG8>"19:00","P")

       

        #NAME? 
          
          
       01-Oct02-Oct03-Oct
      RestdayThursdayFridaySaturday
      Monday6:146:126:39

       

      Thanks

    • ApolloJFK's avatar
      ApolloJFK
      Copper Contributor
      Jul 26, 2019

      Thank you SergeiBaklan .  I just installed the Office 365 version and now it works.