Now, that would be confusing.. Just needed to know the proceedure to substract, I realized from the post, I was not using the correct formula for the results.
----- Original Message ----- From: "Norman King" <[email protected]> To: <[email protected]> Sent: Monday, October 15, 2012 9:53 AM Subject: Re: [JAWS-Users] Subtracting in Excel Hi. You are trying to subtract correct? Why would you add if you are trying to subtract? I guess maybe if you want to add a column and then subtract by a given number which is what that formula looks like. Norman -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Trish Sent: Monday, October 15, 2012 10:34 AM To: [email protected] Subject: Re: [JAWS-Users] Subtracting in Excel Thank you for the help. One question here, the =C3-C4 doesn't need the SUM added? Maybe that's where I'm going wrong.. Many Thanks, Trish ----- Original Message ----- From: "David" <[email protected]> To: <[email protected]> Sent: Monday, October 15, 2012 9:29 AM Subject: Re: [JAWS-Users] Subtracting in Excel Let's take the example given =C3-SUM(C4:C20) and suppose you only want to subtract 1 cell C4. Use the following: =C3-C4 HTH David Bailey -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Trish Sent: Monday, October 15, 2012 9:56 AM To: Jaws Users List Subject: [JAWS-Users] Subtracting in Excel Someone provided this info and I saved it, I have tried to do the steps here and it works with this many cells, but I only want to subtract one cell from the other and that's where it get's messed up. So whoever provided this info, could you please explain how I would go about getting same results for just one or 2 cells? Thanks, Trish Here's one way to subtract c4 through c20, a list of charges, from c3--the beginning balance: =C3-SUM(C4:C20) For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
