Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel IF function

 Hi All,

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.

ProcessTotal receivedDone cases Status/Remarks Pending Cases
A1005858% In Progress 
B25612047% In Progress 
C400400Done 
D7878Done 
E502040% In Progress 
F0 Not Received 
G0 Not Received 
H0 Not Received 
I152  
J255  
K0   
L0   
M1   


I am highly thankful to you.

Waiting for your reply.

Regards,

Debapriya





  Debapriya Bej

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any