Den 2011-03-09 13:51:19 skrev Dan Lewis <[email protected]>:
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" <[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
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: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
--
Kind regards
Johnny Rosenberg
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
