Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: I'm so confused about cell references!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    0 0
     

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-20 15:51, laxchica23 wrote:
    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.
    Hi laxchica23:
    I suggest first thing you do is layout the facets of the problem as you would do manually with pen and paper. Once you know how to do it manually, the next task would be to computerize it.
    This would be the best way to learn about cell values, cell references ... relative, absolute, and mixed.
    However don't let it overwhelm you ... you are the boss, and the computer is a tool at your command.
    So, first figure it out on paper what formulas would be needed, and then post what specific formula you need help with.
    Good Luck!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com
    0 0
     

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •