Difference in %

[mas550]

I am hoping someone knows the formula to find the differance between 2 numbers and return the result in a %
I have last years sales and this years sales to date and i need to determine what percent of last years sales we have achived and the percent of growth.

 

[edokhotnik]

I am hoping someone knows the formula to find the differance between 2 numbers and return the result in a %
I have last years sales and this years sales to date and i need to determine what percent of last years sales we have achived and the percent of growth.

Format your result cells as percentage and try:

Excel Workbook
	A	B	C	D
1	Sales2010	Sales2011YTD	PercentOf2010	PercentChange
2	150000	158000	105.33%	5.33%
3	140000	138000	98.57%	-1.43%
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C2	=B2/A2
C3	=B3/A3
D2	=B2/A2-1
D3	=B3/A3-1

 

[mas550]

thank you!!! i knew there had to be an easy way to do that... ok new question i want to count how many cells in column b have values that exceed that of column d
1 0 4
5 0 2
4 0 2

result should be 1

 

[Brian from Maui]

Might be overkill, but......

=SUMPRODUCT(--(C1:C10>B1:B10))