1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Formula will not calculate correctly

Discussion in 'Business Applications' started by iagoman, Feb 12, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    I am using a spreadsheet sent to me by my company. I usually
    make adjustments, ie adding in a formula on a price list.
    When I key the formula into the first cell, I obtain the correct result.
    Then, when I drag the original cell ,which contains the formula, to fill remaining the cells below, instead of recalculating the new values, it keeps the same value as the original cell.
    However, when I key in the formula into one of these "dragged" cells, the result is correct.
    Am I missing something? I thought I knew Excel well enough
    to do this simple task, alas, I apparently don't.

    Any help would be appreciated. I have to get a lot done and
    I'm stuck.
    I'm using Excel 2000, v 9.0.2720, winxp home. I'm up-to-date
    on all MS updates.
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    1. What is the formula?

    2. Do you have Tools -- Options -- Calculation set to Manual?

    Rgds,
    Andy
     
  3. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    does the original formula use an absolute cell reference looking like $a$1

    If that is the case, then remove the absolute references

    If that isn't the case, then post an example of the formula
     
  4. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    The formula is a simple one,
    "sum=(A24/1.75)*.785"
    I'm not using absolute cell reference.
    Tools/Options/calculation set to MANUAL.
     
  5. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> Tools/Options/calculation set to MANUAL.

    Then set it to AUTOMATIC.

    There's a weird thing about Manual ; something about if the first file you open is in Manual "mode", subsequent files you open will be too.

    Rgds,
    Andy
     
  6. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    IYOU people are GREAT. I set it to AUTOMATIC and all is well, phew!. This site is THE BEST on the new., Now I can enjoy the weekend.
     
  7. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    That should read "Best on the Net". I was so excited it worked, I couldn't type accurately.
     
  8. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    >> Now I can enjoy the weekend

    But it's only Thursday (?)

    Have a good one,
    Andy
     
  9. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    Andy, we are just lucky people. We leave on Thur for our
    weekend cabin and return on Sunday. It's supposed to be
    about -20 degrees Fahrenheit tonight, but it's a crisp,
    beautiful night and the stars are crystal clear.
    Steve (Iagoman).:D
     
  10. crossidbear

    crossidbear

    Joined:
    Aug 20, 2003
    Messages:
    14
    I live in Houston. Haven't seen the stars in 20 years, 'cept when I go to Montana. Dirty air and lights! It's about 45 here.
     
  11. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    I've got another odd situation. We have a excel spreadsheet
    with the "euro" symbol. When my wife prints it on her HP Laset Jet 4l, the euro symbol doesn't show, yet when the s/s was sent to me via email, from my wife's laptop, and I then printed it, the euro symbol shows up properly. I use a Canon S520.
    We are both running Excel 2000, on WinXp Home.
    Any ideas?
     
  12. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
  13. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    RandyG, Tks for the info, but I think the problem lies elsewhere.
    The Euro symbol shows up properly on the screen. It is when
    we print the spreadsheet, that the symbol doesn't show up.
    And, as I said, it does show up when I print it on my printer, a Canon S520 from my laptop, a Toshiba Satellite.
    When my wife tries printing it from her laptop, an HP Pavilion, to her HP LaserJet 4L, that's when the euro symbol doesn't appear.
    Her version of Excel 2000 is 9.0.2720 and mine is
    Excel 2000 version 9.0.6926 SP-3
    Do you think that the problem is in the difference of the versions?
     
  14. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
  15. iagoman

    iagoman Thread Starter

    Joined:
    Nov 5, 2003
    Messages:
    469
    First Name:
    Steve
    RandyG,
    We will give it a try. I sent the site to d/l the fix to my Frau ,(she's German), and we will post back here about the results.
    Don't be concerned that you mis-read my earlier post...I can get a bit "wordy" and sometime obfusticate the point.
    (I always wanted to use that word.).
    (y)
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/203054

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice