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. 


Thread Tools  Display Modes 
#1




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




Percentage remaining
say you have 150,000 in cell A1 and 51,000 in cell B1. use this formula in cell C1 =(A1B1)/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




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 =(I7F7)/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 > > =(A1B1)/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




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 =(I7F7)/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 > > > > =(A1B1)/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




Percentage remaining
The formula is correct and should return 68.2% remaining if your numbers are
correct in I7 and F7 Reenter 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 =(I7F7)/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 >> >> =(A1B1)/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




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 =(I7F7)/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 > > > > > > =(A1B1)/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  


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 