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.
