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