I'm so confused about cell references!

laxchica23 · Apr 20th, 2002, 04:47 PM

Here are the questions from the textbook that I have been using. Question #1: The sales manager wants to know the expected sales for the first quarter of 1998 if the company raises prices. If the company raises prices, the first quarter sales of '98 should increase 3% from the 4th quarter totals for '97. enter formulas using cell ref. to calculate the total sales for the 1st quarter of '98 for each item if there is a price increase. the data is entered in column F and that's all the book says!

[ This Message was edited by: laxchica23 on 2002-04-20 15:53 ]

Mark W. · Apr 20th, 2002, 04:49 PM

What do you think the answer is? Into which cells is the data entered?

[ This Message was edited by: Mark W. on 2002-04-20 15:50 ]

Yogi Anand · Apr 20th, 2002, 05:45 PM

Hi laxchica23:
I just posted you a response to a similar post from you a few minutes ago.
Now I see that Mark has posted a response to you on the same duplicated post.
Please post a question once. You do not need to post the same question again. You will get better help by maintaining the same thread.
Please review Mark's comments and my comments to your question ... you may have to sit down with pen and paper, do some thinking, and then ask for specific help.
Good Luck!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 04:47 PM	#1
laxchica23 New Member Join Date: Apr 2002 Posts: 4	Here are the questions from the textbook that I have been using. Question #1: The sales manager wants to know the expected sales for the first quarter of 1998 if the company raises prices. If the company raises prices, the first quarter sales of '98 should increase 3% from the 4th quarter totals for '97. enter formulas using cell ref. to calculate the total sales for the 1st quarter of '98 for each item if there is a price increase. the data is entered in column F and that's all the book says! [ This Message was edited by: laxchica23 on 2002-04-20 15:53 ]

Apr 20th, 2002, 04:49 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What do you think the answer is? Into which cells is the data entered? [ This Message was edited by: Mark W. on 2002-04-20 15:50 ]

Apr 20th, 2002, 05:45 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi laxchica23: I just posted you a response to a similar post from you a few minutes ago. Now I see that Mark has posted a response to you on the same duplicated post. Please post a question once. You do not need to post the same question again. You will get better help by maintaining the same thread. Please review Mark's comments and my comments to your question ... you may have to sit down with pen and paper, do some thinking, and then ask for specific help. Good Luck!