Skip navigation

Percentage Formula

526 Views 4 Replies Latest reply: May 2, 2012 12:00 PM by Delphinefrompa RSS
Delphinefrompa Calculating status...
Currently Being Moderated
May 2, 2012 10:16 AM

Hi, I need a formula to calculate the percentage between each cell of column K and L

 

Thanks in advance, Delphine

MacBook Air, Numbers
  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    May 2, 2012 10:49 AM (in response to Delphinefrompa)

    Hi Delphine,

     

    Your problem statement could be interpreted more than one way, I think. Could you give an example?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    May 2, 2012 11:09 AM (in response to Delphinefrompa)

    Delphine,

     

    You left out the good part!

     

    Do you want to know...

     

    What percentage K is of L

    What percentage L is of K

    What the percentage of the difference between K & L is of the value of L

    What the percentage of the difference between K & L is of the value of K

     

    Here's the gamut:

    Screen Shot 2012-05-02 at 2.08.20 pm.png

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.