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 01, 2023

HansVogelaar The difference between 'Not completed' and 'in progress' is that in the first phrase no filled in cell in the range of cells is filled, while in seconde phrase in progress a part of the range of cells is filled

HansVogelaar's avatar
HansVogelaar
MVP
May 01, 2023

Saud 

Ah, that's different from

    if any of the cells is not filled, ther phrase appears "not completed"

 

Let's say you want to look at D2:G2.

 

=IFS(ISNUMBER(MATCH("off", D2:G2, 0)), "Off", COUNTIF(D2:G2, "<>")=0, "Not Completed", COUNTIF(D2:G2, "=")>0, "In Progress", TRUE, "Completed")

 

This can be filled down.

  • Saud's avatar
    Saud
    Brass Contributor
    May 01, 2023
    Thank you, I appreciate your effort

Resources