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









" wrote:

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

Hi

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

" wrote in message
...
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