Home 
Search 
Today's Posts 
#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. 
#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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
#of days remaining to the EOM  Excel Discussion (Misc queries)  
Number of payments remaining  Excel Worksheet Functions  
Getting remaining entries  Excel Discussion (Misc queries)  
data remaining in place  Excel Discussion (Misc queries)  
Calculate Remaining Balance  Excel Worksheet Functions 