Remember Me?

#1
April 1st 09, 06:42 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 3
Percentage remaining

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.

#2
April 1st 09, 06:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 82
Percentage remaining

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

"LindaW" wrote:

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.

#3
April 1st 09, 07:56 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 3
Percentage remaining

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

"JonR" wrote:

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

"LindaW" wrote:

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.

#4
April 1st 09, 08:14 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 82
Percentage remaining

You have the right formula and appear to have set up the sheet correctly. I

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

"LindaW" wrote:

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

"JonR" wrote:

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

"LindaW" wrote:

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.

#5
April 1st 09, 08:34 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,908
Percentage remaining

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

On Wed, 1 Apr 2009 11:56:02 -0700, LindaW
wrote:

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

"JonR" wrote:

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

"LindaW" wrote:

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.

#6
April 1st 09, 08:37 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 3
Percentage remaining

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

"JonR" wrote:

You have the right formula and appear to have set up the sheet correctly. I

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

"LindaW" wrote:

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

"JonR" wrote:

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

"LindaW" wrote:

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Narnimar Excel Discussion (Misc queries) 5 September 15th 08 07:53 PM Erik Excel Worksheet Functions 4 May 29th 08 12:22 PM harvindersingh1 Excel Discussion (Misc queries) 1 April 21st 06 03:32 PM ben simpson Excel Discussion (Misc queries) 1 March 13th 06 10:13 PM cindi Excel Worksheet Functions 2 December 8th 04 05:41 PM

All times are GMT +1. The time now is 12:17 PM.