[users] Re: Multiplication
Hello, On Sun, 6 Mar 2011 15:20:26 -0600 Dick Smith rpsmith...@neb.rr.com wrote: Can you give me a simple example of multiplying one Column (B), all lines on worksheet times 80% for all lines Column (C) amounts? Let me try what you want to do. You might have work hours in column B, hourly pay in column C and the company you're billing to has an agreement, that you only charge for 80% of the total cost? Is this idea correct? If so, what you would want to enter in either A1 or D1 is: =B1 * C1 * 0,8 If you want to be able to change the percentage quickly you should enter it in a separate cell before your actual data. Say your percentage entry is in cell A1, then the formula changes as follows: =B1 * C1 * $A$1 The $ signs fix the entry for the cell, so if you copy the formula to other cells, the reference for A1 stays the same, while B1 and C1 change. Hope this helps. Sigrid -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Multiplication
Comment inline. On Wed, 2011-03-09 at 13:38 +0100, Sigrid Carrera wrote: Hello, On Sun, 6 Mar 2011 15:20:26 -0600 Dick Smith rpsmith...@neb.rr.com wrote: Can you give me a simple example of multiplying one Column (B), all lines on worksheet times 80% for all lines Column (C) amounts? Let me try what you want to do. You might have work hours in column B, hourly pay in column C and the company you're billing to has an agreement, that you only charge for 80% of the total cost? Is this idea correct? If so, what you would want to enter in either A1 or D1 is: =B1 * C1 * 0,8 In the United States this equation is = B1 * C1 * 0.8 (Sigrid lives in a part of the world where the use of commas and periods is the opposite of how the US does it. We write 1,003.25. and Others write 1.003,25. These numbers are the same. Hope this helps too.) Dan If you want to be able to change the percentage quickly you should enter it in a separate cell before your actual data. Say your percentage entry is in cell A1, then the formula changes as follows: =B1 * C1 * $A$1 The $ signs fix the entry for the cell, so if you copy the formula to other cells, the reference for A1 stays the same, while B1 and C1 change. Hope this helps. Sigrid -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Multiplication
Den 2011-03-09 13:51:19 skrev Dan Lewis elderdanle...@gmail.com: Comment inline. On Wed, 2011-03-09 at 13:38 +0100, Sigrid Carrera wrote: Hello, On Sun, 6 Mar 2011 15:20:26 -0600 Dick Smith rpsmith...@neb.rr.com wrote: Can you give me a simple example of multiplying one Column (B), all lines on worksheet times 80% for all lines Column (C) amounts? Let me try what you want to do. You might have work hours in column B, hourly pay in column C and the company you're billing to has an agreement, that you only charge for 80% of the total cost? Is this idea correct? If so, what you would want to enter in either A1 or D1 is: =B1 * C1 * 0,8 In the United States this equation is = B1 * C1 * 0.8 (Sigrid lives in a part of the world where the use of commas and periods is the opposite of how the US does it. We write 1,003.25. and Others write 1.003,25. These numbers are the same. Hope this helps too.) Dan There are more variants as well, like the one I prefer: 1 003,25. If you want to be able to change the percentage quickly you should enter it in a separate cell before your actual data. Say your percentage entry is in cell A1, then the formula changes as follows: =B1 * C1 * $A$1 The $ signs fix the entry for the cell, so if you copy the formula to other cells, the reference for A1 stays the same, while B1 and C1 change. Hope this helps. Sigrid -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help