Results 1 to 3 of 3

Thread: Formula (2003)

  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula (2003)

    Hi Everyone - in the sample below I need to figure out how to auto apply a formula, rather than manually enter the formula for each row. In Column E i want my grand total. To get the grand total I want to subtract Column E from Column C - In other words, =E6-C7 (grand total); then =E7-C8 (grand total); I want to copy this same formula and apply it in all the cells for Column E to get a grand total. Hope this made sense <img src=/S/bash.gif border=0 alt=bash width=35 height=39>
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula (2003)

    Enter the formula =E6-C7 in cell E7.
    Make sure that E7 is selected.
    You'll see a little black square in the lower corner of the cell; this is called the fill handle.
    If you double click the fill handle, the formula will be filled down until the end of the data in column D.
    When you add a new row of data, Excel will probably auto-enter the formula in the new row (if the check box "Extend data range formats and formulas" in the Edit tab of Tools | Options is ticked)

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula (2003)

    Thanks to both of you! I knew I could count on the Lounge - <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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