Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exporting from Excel to a Fixed Length Flat File | Excel Worksheet Functions | |||
No showing of cellnumbers used in formular with colour | Excel Worksheet Functions | |||
Graph with variable data length | Excel Discussion (Misc queries) | |||
array formular | Excel Worksheet Functions | |||
How to protect the formular | Excel Discussion (Misc queries) |