View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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!