A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Percentage remaining



 
 
Thread Tools Display Modes
  #1  
Old April 1st 09, 06:42 PM posted to microsoft.public.excel.misc
LindaW
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.
Ads
  #2  
Old April 1st 09, 06:53 PM posted to microsoft.public.excel.misc
JonR
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.

  #3  
Old April 1st 09, 07:56 PM posted to microsoft.public.excel.misc
LindaW
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.

  #4  
Old April 1st 09, 08:14 PM posted to microsoft.public.excel.misc
JonR
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.

  #5  
Old April 1st 09, 08:34 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 22,911
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.


  #6  
Old April 1st 09, 08:37 PM posted to microsoft.public.excel.misc
LindaW
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 10:29 AM.


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