Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2008
    Thanked 0 Times in 0 Posts

    Using formulas (XP)

    Please refer to the attached file. Without sorting the % achieved column, what is the formula that I can use such that it'll help me auto calculate in cell B14 to B16 the total amount for each category?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Using formulas (XP)

    Welcome to Woody's Lounge!

    You can enter the following formula in B14:


    Copy down to B15 and B16, then edit the resulting formulas to use 75% and 25%.

    You could enter the values 100%, 75% and 25% in A14:A16, and format them with the custom format 0% "achieved"
    You can then use the formula


    in B14 and fill down to B15 and B16 without needing to modify the result. See the attached version.
    Attached Files Attached Files

Posting Permissions

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