Calculation Question

L

Larry

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

Sean Timmons

=B7*1.05 gives you the increase.

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

Pete_UK

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
 
L

Larry

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
 
D

David Biddulph

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.
 
Top