4 Replies Latest reply: May 2, 2012 12:00 PM by Delphinefrompa
Level 1 (0 points)

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

MacBook Air, Numbers
• Level 7 (29,950 points)

Hi Delphine,

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

Jerry

• Level 1 (0 points)

Well I sure can:) I need to find the percentage between the number in my column K and the one in my column L

K                              L

119000                    109000

Hope that would help, for you to help me

Have a good day

Delphine

• Level 7 (29,950 points)

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:

Jerry

• Level 1 (0 points)

Thank you Jerry !!

I needed the second possibility

Have a good day

Delphine