MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula is too long


Posted by Michael on October 12, 2000 1:29 PM

My formulas make multiple references to cells on
another worksheet, and each time the full name of the
other sheet is included in the formula -- making the
formulas much larger and appear more complex than they
need to be.

For example:
=Sheet1!A1-Sheet1!A2+Sheet1!C4-Sheet1!E1+Sheet1!B7
+Sheet1!H1-Sheet1!J1

Is there anyway to eliminate some of the "Sheet1"
references?


Posted by Ivan Moala on October 13, 2000 1:59 AM

One way is ;
Goto Insert / name /define

Type in "MyName" or what ever
Then define your Ref here eg =Sheet1!A1-Sheet1!A2+Sheet1!C4-Sheet1!E1+Sheet1!B7

etc

Then in any cell just type in

=MyName


Ivan

Posted by AB on October 13, 2000 8:47 AM

You could make it a practice to seperate your links from your formulas.

Put your links on a "Link" sheet and then just let your formulas refer to the Link!A1 cell or whatever.