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.

 Percentage remaining
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Percentage remaining

#1
April 1st 09, 06:42 PM posted to microsoft.public.excel.misc
 LindaW external usenet poster 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
 JonR external usenet poster 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
 LindaW external usenet poster 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
 JonR external usenet poster 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
 Gord Dibben external usenet poster Posts: 22,909
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
 LindaW external usenet poster 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.

 Thread Tools Display Modes Linear Mode

 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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 09:13 PM Calculate Remaining Balance cindi Excel Worksheet Functions 2 December 8th 04 04:41 PM

All times are GMT +1. The time now is 03:53 AM.