Calc percentage of goal if looking to decrease from actual.

[Playmedead]

I've been off work a while and I just want to make sure I'm doing it properly. Goal call hold time is 300 seconds but actual is 660 seconds. I want to calculate progress toward goal of 300 seconds as a percentage. I have 45% as the achievement toward that goal...is that correct? Note: in the formula I have it capped at 100% if the goal were to be overshot.

I'm assuming this: actual-goal/actual, is this the correct way to measure this?

Book1
	A	B	C	D
1		Goal	Actual	% of Goal
2	seconds	300	660	45%
Sheet1

Cell Formulas
Range	Formula
D2	D2	=IF(C2>B2,1-(C2-B2)/C2,1)

 

[JpMakako]

If i understand you correctly it should be Correctly you are showing "accumulated" progress so the formula is correct.

 

[Playmedead]

If i understand you correctly it should be Correctly you are showing "accumulated" progress so the formula is correct.

Thanks. Yes if we need to get to 300 from 660 seconds, that's a 55% decrease, leaving 45% as the progress so far.