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!

=B7*1.05 gives you the increase.

Or are you lookign for the cel lto show the %, then show the changed amount?


"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!

I think you need something like this:

=C7*1.05 to add 5%, or

=C7*0.95 to subtract 5%

Is this what you mean?

Pete

On Feb 5, 11:26 pm, 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!

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!

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!