I was wondering if a complex formula can be assigned a range name and if so how is this done? Thanks in advance.
I was wondering if a complex formula can be assigned a range name and if so how is this done? Thanks in advance.
Last edited by DorothyFan1; 10-13-2011 at 10:28 AM.
In the Formulas Tab click Define a Name.
Give it a name say Tax
Refers to = 0.20
Click OK
In any cell type =100*Tax
You can adapt this for your formula
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks