Results 1 to 2 of 2

Thread: help required on developing a formula

  1. #1

    help required on developing a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I need help with creating a formula that calculates success rate (percentage of successful projects vs all) in the Success rate percentage tab of the attached file based on the True/false date in the project list tab (column L). Can you help?
    Attached Files Attached Files

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Hello
    In order to devise a formula, I need to understand the points at which the calculation is needed. You say it is based on column L, which suggests one percentage based on the proportion of cells in the column that evaluate to TRUE. However, that doesn't explain all the date headers in the SCP sheet, so I gather that you have forgotten to describe how they fit in.
    Can you add a couple of examples of the percentage calculation?

Posting Permissions

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