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"))
Sam_Perryman's avatar
Sam_Perryman
Copper Contributor
Jun 19, 2021
Thank you Sergei for your time.
BINGO!!
Thank you

Resources