View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hetal hetal is offline
external usenet poster
 
Posts: 1
Default 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