ah, this should get the job done, thanks ----- Original Message ----- From: "Mike O'Brien" <[email protected]> To: <[email protected]> Sent: Monday, October 15, 2012 12:24 PM Subject: Re: [JAWS-Users] Subtracting in Excel
Hi If you wanted to subtract the one cell c4 from c3, use =c4-c3. If you wanted to subtract both cells c4 and c5 from c3, you could use =c3-c4-c5. The original formula you sent says you want to subtract each of cells c4 through c20 from c3. You could use =c3-c4-c5-c6-c7-c8-c9-c10-c11-c12-c13-c14-c15-c16-c17-c18-c19-c20, But it would be easier to add all those cells together and then subtract that sum from c3. There are minus signs between each of those cells, in case your JAWS does not say them. Thus the use of the sum function. For the second case above, you could have used =c3-sum(c4:c5). -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Trish Sent: Monday, October 15, 2012 10:58 To: [email protected] Subject: Re: [JAWS-Users] Subtracting in Excel 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/ 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/
