View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis
 
Posts: n/a
Default looking for simplified formulas

looking for simplified formulas

Hi. Most of your variables cancell out.
This part:
=(B1-A1)+(C1-B1)+(D1-C1)+(E1-D1)
Reduces to
E1-A1

(Did you mean multiply? =(B1-A1) * (C1-B1) *...)
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"philip" wrote in message
...
I have formulas as following:
=(B1-A1)+(C1-B1)+(D1-C1)+(E1-D1)+..........+(AB1-AA1)

Is any one can help???

thanks
philip