Share via

Nested IF (ISBLANK)

Anonymous
2018-03-27T07:53:31+00:00

I need a formula in the status column that results in the symbols (Numbers next to them) when information is entered as pictured in the table.

So, if a date is entered in just the opened date column, it will result in 0. Then if a date is entered into the target date column it results in 2, and so on...

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2018-03-27T08:35:33+00:00

=IF(COUNTIF(M8:O8,"<>"&"")+COUNTIF(B8,"<>"&"")=0,"",2*(COUNTIF(M8:O8,"<>"&"")+COUNTIF(B8,"<>"&"")-1))

Was this answer helpful?

3 people found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-27T08:33:54+00:00

    That's great, just one thing.

    How can I keep that cell blank when no dates are entered anywhere?

    Thanks in advance.

    Was this answer helpful?

    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-03-27T08:22:36+00:00

    You can use following formula in P8 and drag down

    =2*(COUNTIF(M8:O8,"<>"&"")+COUNTIF(B8,"<>"&"")-1)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-03-27T08:07:18+00:00

    Was this answer helpful?

    0 comments
  4. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-03-27T07:54:41+00:00

    I need to have a look on your workbook to provide you the solution specific to your problem.

    Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

    Was this answer helpful?

    0 comments