percentage formula ?

jdanielurx · Mar 19th, 2002, 03:13 PM

i want to track cost to complete on my spread sheet
example:
cost to date is $750.00
project is 75% complete
what is the cost to complete?
i am having problems with the right formula
thanks for any help

Aladin Akyurek · Mar 19th, 2002, 03:17 PM

In C1 enter:

=A1-B1*A1

where A1 houses $750.00 and B1 75%.

Mark W. · Mar 19th, 2002, 03:17 PM

Quote:

On 2002-03-19 14:13, jdanielurx wrote:
i want to track cost to complete on my spread sheet
example:
cost to date is $750.00
project is 75% complete
what is the cost to complete?
i am having problems with the right formula
thanks for any help

=750*(1-.75)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 03:13 PM	#1
jdanielurx New Member Join Date: Mar 2002 Posts: 2	i want to track cost to complete on my spread sheet example: cost to date is $750.00 project is 75% complete what is the cost to complete? i am having problems with the right formula thanks for any help

Mar 19th, 2002, 03:17 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	In C1 enter: =A1-B1*A1 where A1 houses $750.00 and B1 75%.