Need formula to show % complete

[RickeyS]

Hi,

I need a formula to show % complete,

I have a list of names in column A

Column's B thru F will be a task for each person in column A to complete, those columns will have text, or date or be blank to show if a task was completed

Each of these task (column would be a different value). In column B if there is text or a date would be 10% value, if blank would be 0% value, column C would be worth 20% if there is text or a date and again 0% if blank, column D would be worth 5% if there is text or a date and 0% if blank, Column E would be worth 8% if there is text or a date 0% if blank, Column F would be worth 7% if there is text or a date and 0% if blank,

Also in Column G will be a % completed of another task already 0% to 50%.

So the formula needed will be in column H and will need to be like this, but don't know how to write it:

= sum(If B2 is not blank + 10%, if C2 is not blank + 20%, if D2 is not blank +5%, if E2 is not blank + 8%, if F2 is not blank + 7%) + G2

Hopes this makes sense to someone that can help.

Thanks
Rick

 

[mvptomlinson]

Perhaps this will work for you:

=(0.1*(B2<>""))+(0.2*(C2<>""))+(0.05*(D2<>""))+(0.08*(E2<>""))+(0.07*(F2<>""))+G2

Assumes G2 contains a decimal number. Format result as %.

 

[RickeyS]

Thanks,
Works great!
Rick