Calculating 50% complete, returning Yes or No

[candacer]

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.

 

[Niek Otten]

Total in A1, assigned in B1:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.

 

[Mike H]

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