Can anybody help me to create a formula using IF function to update my Shift Closing Work Status. My status sheet is as follows: And there are 3 conditions: I need to update my Status column with "Not Received", "% In Progress" and "Done" using formula.
1. If received work =0, "Not Received";
2. Either "(%) In Progress", if total work not done;
3. "Done" if whole done.
|Process||Total received||Done cases||Status/Remarks||Pending Cases|
|A||100||58||58% In Progress|
|B||256||120||47% In Progress|
|E||50||20||40% In Progress|
I am highly thankful to you.
Waiting for your reply.