#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Percentage remaining

Calculating Percentage Remaining to Reach Sales Goal

To start, we need to find out how much more sales you need to reach your goal of $150,000.00. We can do this by subtracting your current sales of $51,744.42 from your goal of $150,000.00:

$150,000.00 - $51,744.42 = $98,255.58

So you need to make an additional $98,255.58 in sales to reach your goal.

To calculate the percentage remaining, we need to:
  1. Divide the amount of sales remaining by the total sales goal
  2. Multiply the result by 100 to get a percentage

So in this case, we would divide $98,255.58 by $150,000.00:

$98,255.58 / $150,000.00 = 0.6557

Then, we multiply by 100 to get the percentage:

0.6557 x 100 = 65.57%

So the percentage remaining to reach your sales goal of $150,000.00 is 65.57%.

I hope that helps!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default 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

Please rate your posts


"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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

Please rate your posts


"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default Percentage remaining

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


"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

Please rate your posts


"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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

Please rate your posts


"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.


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
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


"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

Please rate your posts


"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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#of days remaining to the EOM Narnimar Excel Discussion (Misc queries) 5 September 15th 08 07:53 PM
Number of payments remaining Erik Excel Worksheet Functions 4 May 29th 08 12:22 PM
Getting remaining entries harvindersingh1 Excel Discussion (Misc queries) 1 April 21st 06 03:32 PM
data remaining in place ben simpson Excel Discussion (Misc queries) 1 March 13th 06 10:13 PM
Calculate Remaining Balance cindi Excel Worksheet Functions 2 December 8th 04 05:41 PM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"