Calculation Question
Perhaps you weren't able to read the replies you received?
The formula you asked for is =B7*1.05
If you prefer it, you can use =B7*(1 + .05)
or =B7 + B7*.05, but they all give the same answer.
--
David Biddulph
"Larry" wrote in message
...
Methinks maybe I need to be a tad bit clearer...(smile) Hopefully this
will
give a better idea:
I have an amount in Cell B7, say, $2500
In Cell B8, I want to calculate and show the result of: B7 * .05, and
then
automatically show the result of that calculation added to the $2500. In
other woddds, cell B8 would have the final result of $2500 x .05 + the
amount
in Cell B7.
Does that help?
Thanks for the replies...I really do appreciate it...
Regards,
Larry
"Larry" wrote:
I want to calculate, in one cell, the result of one calculation that ends
with that calculation being added or subtracted from the primary cell.
Example: Cell B7 has an amount of $2500. I want to calculate how much
of an
increase of 5% is over $2500, then automatically add or subtract that
calculated amount to the $2500 and be shown in the cell in which the
formula
resides...can anyone help...I know I'm right there, but I'm just a tad
short...
Thanks!
|