Forum Discussion

Sam_Perryman's avatar
Sam_Perryman
Copper Contributor
Jun 19, 2021
Solved

IFS Formula or IF formula

Hi  Hoping someone can assist me; I am developing a training matrix as per table below. The status field has the current formula: =IF(G7<0,"Expired",IF(G7<30,"Expiring Soon",""))   The problems...
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 19, 2021

    Sam_Perryman 

    Perhaps

    =IF(G7<0,"Expired",
 IF(G7<30,"Expiring Soon","Active"))

=IFS(G7<0,"Expired", G7<30,"Expiring Soon",TRUE, "Active"))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 19, 2021

Sam_Perryman 

Perhaps

=IF(G7<0,"Expired",
 IF(G7<30,"Expiring Soon","Active"))

=IFS(G7<0,"Expired", G7<30,"Expiring Soon",TRUE, "Active"))
  • Sam_Perryman's avatar
    Sam_Perryman
    Copper Contributor
    Jun 19, 2021
    Thank you Sergei for your time.
    BINGO!!
    Thank you

Resources