Percentage remaining

L

LindaW

I am having trouble calculating the percentage remaining of our goal.
Our goal is $150,000.00 in sales. So far we have sales totaling $51,744.42.
I need to calculate the percentage remaining in order to reach the
$150,000.00.
 
J

JonR

say you have 150,000 in cell A1 and 51,000 in cell B1.

use this formula in cell C1

=(A1-B1)/A1

Format cell C1 as a percentage

--
HTH

JonR

Please rate your posts
 
L

LindaW

I must be doing something incorrectly. I have a goal of $2,000,000. (cell
I7)and so far we have sales against this number of $635.545.71.(cell F7) I
entered the formula =(I7-F7)/I7 and I got -959%

Linda
 
J

JonR

You have the right formula and appear to have set up the sheet correctly. I
tried it with your numbers and can't duplicate your results.

Check your cells for typos. If that doesn't work try typing it into a
different set of cells and see if you get a similar answer (don't cut &
paste, as you'll duplicate the error).
--
HTH

JonR

Please rate your posts
 
G

Gord Dibben

The formula is correct and should return 68.2% remaining if your numbers are
correct in I7 and F7

Re-enter the numbers and enter the formula in J7 or some other empty cell.


Gord Dibben MS Excel MVP
 
L

LindaW

thanks, Jon, I calculated in a new cell and it worked. Thanks again for the
solution.
Linda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top