Formulas

[krisstanley]

I need a formula that will calculate what the difference between two numbers is as a percentage of increase.

 

[PaddyD]

kind of know what you mean, but how about posting back with a worked out example...

Paddy

 

[Aladin Akyurek]

On 2002-09-11 17:30, krisstanley wrote:
I need a formula that will calculate what the difference between two numbers is as a percentage of increase.

Why not give an example to exclude any misunderstanding?

 

[krisstanley]

trying to calculate last years income versus this years income, want to show what percentage the increase is.
$13,716.68 YTD thru pp 13 2001
$19,141.05 YTD thru pp 13 2002
$5,424.37 difference
???? percent of increase

 

[PaddyD]

this sort of thing?

Book7
	A	B	C	D
1	Last	13716.68
2	This	19141.05
3	Difference	5424.37
4	%Increaseonlastyear	40%
5	allatonce:	40%
6
7
Sheet3

Format the results as percents

Paddy

 

[krisstanley]

Thank You! That was perfect. I appreciate the speedy reply.