Calculating 50% complete, returning Yes or No
 

I need a formula that will calculate the percentage of assignments completed
(I have supplied the total number of assignments and the number of
assignments for a specific team in a table on my worksheet already) and
return a "Yes" or "No" value if they are 50% or more complete.

Calculating 50% complete, returning Yes or No
 

Total in A1, assigned in B1:

=IF(B1/A1=50%,"Yes","No")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"candacer" wrote in message ...
|I need a formula that will calculate the percentage of assignments completed
| (I have supplied the total number of assignments and the number of
| assignments for a specific team in a table on my worksheet already) and
| return a "Yes" or "No" value if they are 50% or more complete.

Calculating 50% complete, returning Yes or No
 

Hi,

You don't give too many clues on how your data are laid out so here's a
guess which you may be able to biuld on.

It assumes you assignement numbers are in column A and you mark a 'Y' in
column C when one is complete

=IF(COUNTIF(C:C,"y")/MATCH(9.99999999999999E+307,A:A)0.5,"Yes","No")

Mike

"candacer" wrote:

I need a formula that will calculate the percentage of assignments completed
(I have supplied the total number of assignments and the number of
assignments for a specific team in a table on my worksheet already) and
return a "Yes" or "No" value if they are 50% or more complete.