creating formula for subtraction and then division

[Guest]

i have my number in E11 and E10 like this

E11 "884.90"
E10 "868.05"

i want my ans as E11-E10/E10 like this (868.05-884.90)/868.05
how to create formula for this?

i want to use this function for the whole sheet..so how do i do it?

 

[David Biddulph]

=(E11-E10)/E10 or
=E11/E10-1

 

[Guest]

You are almost there:

=(E11-E10)/E10

The excel formula is an exact match for your algebraic equation.

Copy its syntax where ever you need it,

 

[Fred Smith]

The same way you did it manually. Use:

=(e11-e10)/e10

For the whole sheet grab the fill handle (the little black box on the bottom
left of the highlighted cell), and drag down as far as you want. Excel will
adjust the cell references as it goes along.