Forum Discussion

Saud's avatar
Saud
Brass Contributor
May 01, 2023
Solved

Tasks

I want a function for multiple conditions where it says that if a certain number of cells are filled, knowing that there are numbers and text in those cells, if all these cells are filled the phrase ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 02, 2023

    Saud 

    Does this work?

    =IFS(ISNUMBER(MATCH("off", B2:G2, 0)), "Off", COUNTIF(B2:G2, "<>")=0, IF(A2<TODAY(), "Delay in Task Monitoring", "Not Completed"), COUNTIF(B2:G2, "=")>0, IF(A2<TODAY(), "Delay in Task Monitoring", IF(A2=TODAY(), "In Progress", "Not Yet Due")), TRUE, "Completed")

Saud's avatar
Saud
Brass Contributor
May 02, 2023

HansVogelaar 

 

yes of course attached workbook

HansVogelaar's avatar
HansVogelaar
MVP
May 02, 2023

Saud 

Does this work?

=IFS(ISNUMBER(MATCH("off", B2:G2, 0)), "Off", COUNTIF(B2:G2, "<>")=0, IF(A2<TODAY(), "Delay in Task Monitoring", "Not Completed"), COUNTIF(B2:G2, "=")>0, IF(A2<TODAY(), "Delay in Task Monitoring", IF(A2=TODAY(), "In Progress", "Not Yet Due")), TRUE, "Completed")

Resources