MS Excel If-Then-Else Hi, Trying to formulate an if-then-else statement to chang

Question

MS Excel If-Then-Else

Hi,

Trying to formulate an if-then-else statement to change the status value of a cell based upon the presence or lack thereof the following three dates, requested, assigned, and completed.

Any advice would be greatly appreciated.

Column D = Status (unassigned, assigned, completed)

Unassigned = request date only exists (col A)

Assigned = request date and assigned date exist but not a completed date (col K)

Completed = completed date exists (col R)

Thanks very much in advance !!

Explanation / Answer

Hi..

In D2:

=IF(R2<>"","Completed",IF(K2<>"","Assigned",IF(A2<>"","Unassigned","")))

This formula can be filled down.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.