Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Excel Help

  1. #1
    Bull$hit Radar Chun Li's Avatar Chun Li is offline
    Join Date
    Jan 2000
    Location
    Brooklyn
    Posts
    3,598
    Credits
    1,343,619

    Excel Help

    How do i use the sum button to subtract instead of add?

  2. #2
    Super Moderator Jason kiDD's Avatar Jason kiDD is offline
    Join Date
    Jul 2003
    Location
    Da Streets
    Posts
    42,527
    Credits
    7,664,113

    About.com

    Changing the Autosum to Subtract in Excel
    We're not finished with this autosum yet. Notice that between the two cell references in the formula that here is a comma. That comma is a sort of short hand and serves to add the two cells together. This isn't what we want the autosum to do. We want a formula that will subtract our expenses from our income. To do this, click on the formula bar and change that comma to a minus sign then hit enter.

  3. #3
    You worserer than I Essiquibo's Avatar Essiquibo is offline
    Join Date
    Jan 2000
    Location
    NYC
    Posts
    22,958
    Credits
    1,045,172
    a minus sign in your formula

  4. #4
    Bull$hit Radar Chun Li's Avatar Chun Li is offline
    Join Date
    Jan 2000
    Location
    Brooklyn
    Posts
    3,598
    Credits
    1,343,619
    Quote Originally Posted by PJK
    Changing the Autosum to Subtract in Excel
    We're not finished with this autosum yet. Notice that between the two cell references in the formula that here is a comma. That comma is a sort of short hand and serves to add the two cells together. This isn't what we want the autosum to do. We want a formula that will subtract our expenses from our income. To do this, click on the formula bar and change that comma to a minus sign then hit enter.
    i don't see a coma only : and ()

  5. #5
    Super Moderator Jason kiDD's Avatar Jason kiDD is offline
    Join Date
    Jul 2003
    Location
    Da Streets
    Posts
    42,527
    Credits
    7,664,113
    you cannot subtract from a range of numbers, I dont think..

    =SUM(A1-A5)
    Last edited by Jason kiDD; 06-06-2006 at 12:05 PM.

  6. #6
    Lucy-furrr yanktiguan's Avatar yanktiguan is offline
    Join Date
    Mar 2004
    Location
    BK
    Posts
    16,432
    Credits
    1,011,698
    make the number negative. use parenthesis around the quantity.
    Last edited by yanktiguan; 06-06-2006 at 12:34 PM.

  7. #7
    Kiz
    Registered User Kiz's Avatar Kiz is offline
    Join Date
    Jul 2004
    Location
    On top yuh man
    Posts
    29,572
    Credits
    1,044,600
    How do I make ah dollar outta 15 cents

  8. #8
    OnE eYe MoNsTeR InC. Snapshot's Avatar Snapshot is offline
    Join Date
    Mar 2004
    Location
    BK
    Posts
    3,555
    Credits
    1,005,937
    Quote Originally Posted by yanktiguan
    make the number negative. use hypothesis around the quantity.

    what is theorizing about the quantity gonna accomplish for her


    did u mean parentheses...

  9. #9
    Lucy-furrr yanktiguan's Avatar yanktiguan is offline
    Join Date
    Mar 2004
    Location
    BK
    Posts
    16,432
    Credits
    1,011,698
    Quote Originally Posted by Snapshot
    what is theorizing about the quantity gonna accomplish for her


    did u mean parentheses...

    oops... typo

  10. #10
    Kiz
    Registered User Kiz's Avatar Kiz is offline
    Join Date
    Jul 2004
    Location
    On top yuh man
    Posts
    29,572
    Credits
    1,044,600
    Quote Originally Posted by yanktiguan
    oops... typo

    Suuuuuuuuurrrrrrrreeee

  11. #11
    Lucy-furrr yanktiguan's Avatar yanktiguan is offline
    Join Date
    Mar 2004
    Location
    BK
    Posts
    16,432
    Credits
    1,011,698
    Quote Originally Posted by Trinikiz
    Suuuuuuuuurrrrrrrreeee

    happy birthday kizzy!!!

  12. #12
    Kiz
    Registered User Kiz's Avatar Kiz is offline
    Join Date
    Jul 2004
    Location
    On top yuh man
    Posts
    29,572
    Credits
    1,044,600
    Quote Originally Posted by yanktiguan
    happy birthday kizzy!!!


  13. #13
    OnE eYe MoNsTeR InC. Snapshot's Avatar Snapshot is offline
    Join Date
    Mar 2004
    Location
    BK
    Posts
    3,555
    Credits
    1,005,937
    Quote Originally Posted by Trinikiz

    it's gonna be a loooooooong day fuh u

  14. #14
    Super Moderator Jason kiDD's Avatar Jason kiDD is offline
    Join Date
    Jul 2003
    Location
    Da Streets
    Posts
    42,527
    Credits
    7,664,113
    Quote Originally Posted by Trinikiz
    Chennette stocks are rising!! :

  15. #15
    Kiz
    Registered User Kiz's Avatar Kiz is offline
    Join Date
    Jul 2004
    Location
    On top yuh man
    Posts
    29,572
    Credits
    1,044,600
    Quote Originally Posted by Snapshot
    it's gonna be a loooooooong day fuh u

    if again!

Page 1 of 2 12 LastLast

Posting Permissions

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