On 12/02/2008, Kristy Lisby <[EMAIL PROTECTED]> wrote: > > Dear Sir or Madam: > I am wanting to know how to subtract one cell from another so that I can > calculate how much I have actually earned. I have already entered in how > much the product cost, how much the commission is for the site I'm using and > how much the customer paid for the product. > > Thanks, > Kristy M. Reisinger
I assume you are using Calc. Let's say the two numbers are in A1 and B1 and that you want the difference (A1-B1) in cell C1. Position the cursor in C1 and, in the data entry box type "=A1-B1" without the quotes. When you hit Enter, the result will be displayed in C1. Yo can then copy this formula easily down the column; Calc will automatically adjust things so that the correct row number is used. I strongly recommend you go to http://documentation.openoffice.org/ and read the Getting Started guide. Then go to http://wiki.services.openoffice.org/wiki/Documentation and start browsing the Calc documentation. Or, if you prefer, buy one of the books listed at http://support.openoffice.org/ -- Harold Fuchs London, England Please reply *only* to [email protected]
