Excel - encore une fois!

[charlie clown]

What's the best way to do this:

 

I have 5 columns.

Each column contains a status

When the status is set to "Complete" I want a percentage completion too be update in column 6

When only column 1 is Complete the total in column 6 should be 15%

When Columns 1 & 2 are complete the total should be 40%

When Columns 1, 2 & 3 are complete the total should be 70%.

When Columns 1, 2, 3 & 4 are complete the total should be 85%

When Columns 1, 2, 3, 4 & 5 are complete the total should be 100%

 

What's function / formula to get this result in Column 6?

 

TVM.

Edited March 20, 2018 by charlie clown

[Jonesy]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Gethin]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here