Hello, On Sun, 6 Mar 2011 15:20:26 -0600 "Dick Smith" <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected] with Subject: help
