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