You can't have a space in a name, so Excel has probably named the
range "Revenues_2002" (depends on how you defined it), and this does
not tie in with what you have typed in your formula.

Hope this helps.

Pete

On Feb 4, 2:08 am, Carol Ann
wrote:
Afraid that I already knew to do that. I'm supposed to use the formula
"=Revenues 2002*(1+Revenue_Growth)" to show the increase from 2002 to 2003.
Each time I try I get "the formula you typed contains an error".



"Alan Beban" wrote:
Carol Ann wrote:
Good Afternoon:

I am taking an Excel course and this is one of my assignments. I have used
Excel for years but never used named ranges. I have checked online and know
how to select a range and name it, but in this assignment I don't know which
cells to select to name. Can someone help?

Assignment ... Create a workbook consisting of 2 worksheets. Name the first
worksheet tab "Assumptions" and the second worksheet "P&L."

The "Assumptions" worksheet ...

A B C
D E F
1 2002 2003 2004 2005 2006
2 Revenue Growth (%) 2% 4% 3% 5%
3 Expense Growth (%) 3% 3% 2% 5%
4 Tax Rate (%) 16% 15% 12% 13%
. . .
* Create names for data ranges in both worksheets, using row the labels
(hint: select rows and their labels, then Insert „³ Name „³ Create...).

E.g., Select $A$2:$F$2, then Insert|Name|Create and pick a name. Do you
need more?

Alan Beban- Hide quoted text -

- Show quoted text -