View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JonR JonR is offline
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.