creating formula for subtraction and then division
 

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?
--
plz help
-hetal

creating formula for subtraction and then division
 

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

"hetal" wrote in message
...
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?
--
plz help
-hetal

creating formula for subtraction and then division
 

You are almost the

=(E11-E10)/E10

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

Copy its syntax where ever you need it,
--
Gary''s Student
gsnu200712

creating formula for subtraction and then division
 

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.

--
Regards,
Fred


"hetal" wrote in message
...
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?
--
plz help
-hetal