Building a formula

[B_David]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I build a formula that increases the value in a cell by 60%. For example, if the amount in the cell is $100, and I want to increase this amount in the cell by 60%, the amount in the cell would now be $160; not $100. How do I create this formula so I can copy this down to all the cells in the column?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do I build a formula that increases the value in a cell by 60%. For
example, if the amount in the cell is $100, and I want to increase this amount
in the cell by 60%, the amount in the cell would now be $160; not $100. How do
I create this formula so I can copy this down to all the cells in the column?

First you need to understand that a formula can only change the value of the
cell it is in. It can not change the value of another cell. So assume that
cell A1 contains $100. This formula in cell B1 will increase A1 by 60%:
=1.6*A1
You can then fill this formula down as needed.

 

[CyberTaz]

Another option if this is a one time thing - Type 1.6 into a cell, copy the
cell, then select the range of cells containing the values you want to
increase by 60%. Go to Edit> Paste Special, select Multiply in the Operation
section, then click OK - the values in the selected cells will be multiplied
by the 1.6 [increased by 60%].

HTH |:>)
Bob Jones
[MVP] Office:Mac