LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nello
 
Posts: n/a
Default Reducing Formular length

Hi I have a formular that is very long in a workbook I am currently using.
How can I reduce the length of teh formular? The sample formular is presented
below:

='Deployment Cost WorkSheet'!$D50*'Current Dep Plan &
Expec.'!E$14+'Deployment Cost WorkSheet'!$E50*'Current Dep Plan &
Expec.'!E$17+'Deployment Cost WorkSheet'!$F50*'Current Dep Plan &
Expec.'!E$20+'Deployment Cost WorkSheet'!$G50*'Current Dep Plan &
Expec.'!E$23+'Deployment Cost WorkSheet'!$H50*'Current Dep Plan &
Expec.'!E$26+'Deployment Cost WorkSheet'!$I50*'Current Dep Plan &
Expec.'!E$29+'Deployment Cost WorkSheet'!$J50*'Current Dep Plan &
Expec.'!E$32+'Deployment Cost WorkSheet'!$K50*'Current Dep Plan &
Expec.'!E$35+'Deployment Cost WorkSheet'!$L50*'Current Dep Plan &
Expec.'!E$38+'Deployment Cost WorkSheet'!$M50*'Current Dep Plan &
Expec.'!E$41+'Deployment Cost WorkSheet'!$N50*'Current Dep Plan & Expec.'!E$45

Any suggestions will be helpful.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting from Excel to a Fixed Length Flat File bearie Excel Worksheet Functions 4 June 16th 05 02:16 AM
No showing of cellnumbers used in formular with colour /Maria Excel Worksheet Functions 5 June 3rd 05 12:52 PM
Graph with variable data length snoach Excel Discussion (Misc queries) 1 May 27th 05 10:15 AM
array formular LA Excel Worksheet Functions 4 April 21st 05 03:30 AM
How to protect the formular joy Excel Discussion (Misc queries) 1 February 20th 05 05:12 AM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"