+ Reply to Thread
Results 1 to 3 of 3

Need help with % complete formula

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    Maryland
    Posts
    7

    Need help with % complete formula

    Hi everyone. I am trying to calculate the % complete for a document. See attached. The started approach has a 10% weight age, approaches complete has an 80% weight age, and signed-off has a 10% weight age.

    Example 1:

    I have started an approach and 2/8 approaches are complete. The document has been signed-off also.

    The % complete calculation should be: 10% + (80/8) *2 + 10% which equals 40% complete (cell E2).

    Example 2:

    I have started an approach and 4/8 approaches are complete. The document has not been signed-off.

    The % complete calculation should be: 10% + (80/8) *4 which equals 50% complete (cell E2).

    What should the formula for cell E2 be? Thanks a lot for your help guys.
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Need help with % complete formula

    Hello,

    how about

    =IF(A2="yes",0.1,0)+IF(C2=0,0,(0.8/C2)*B2)+IF(D2="yes",0.1,0)

    cheers

  3. #3
    Registered User
    Join Date
    12-18-2008
    Location
    Maryland
    Posts
    7

    Re: Need help with % complete formula

    thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1