lundi 5 juillet 2021

Excel IF formula with 3 outputs in a single cell

I am currently working on a sheet where I'm having an issue.

The problem is that I want 3 different outputs to be shown in a single cell using 3 different conditions. Attaching an image for reference.

Reference Image

Suppose, a person is getting vaccinated and he has taken both shots so the "Ref" cell will show "Done" one after another and the "Status" will show "Done".

Now, there's one guys who hasn't taken any shots yet so the "Ref" cell will show "Incomplete" one after another and the "Status" will show "Incomplete".

But there's a person who has taken his first shot and is awaiting his time for the second shot so the "Ref" cell will show "Complete" and "Incomplete" one after another and here the "Status" should show "Partial".

How can it be done?

Aucun commentaire:

Enregistrer un commentaire