Progress Report

  • Thread starter Thread starter babypink2807
  • Start date Start date
B

babypink2807

Hi

I have 4 columns as follows Call1, Call2, Call3, Call4 and then %
Complete.

So if Call1 has a date in it then the Complete Column should show 25%,
if Call2 has a date in it Complete should show 50%

Can anyone advise of the formula for this, I am really struggling with
it

Thanks in advance
 
try this formula

=IF(AND(A2<>"",B2="",C2="",D2=""),25,IF(AND(B2<>"",C2="",D2=""),50,IF(AND(C2<>"",D2=""),75,IF(D2<>"",100,"no update yet"))))

Generally, this formula does check to see if cell Call 1 is not blank and
populate
the number 25 in %Completed and that Call 2 is not blank and return 50 in
%Completed. Pls note that it doesn't evaluate for a date.

Does this do what you want?

HTH
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis
 
Hi

With data in columns a through D
=COUNT(A1:D1)/4
Format the cell with the formula as %
Change range to suit.
 
Back
Top