software

I'm making a price list and Excel 2003 my cost is in the spreadsheet I would
like to add an exact dollar amount to the cost how can I do this without
retyping the entire number for each and everyone. For example in the current
spreadsheet is listed at a certain item cost $100 I would like that to say
$125 the problem is there's over 300 items and if I had to add $25 to each
item I would have to retype each number all 300 I'm looking for a formula
that I can use to add $25 and then just use to fill handle. Secondly I would
like to also be able to do this by just adding a percentage of the original
number instead of a dollar amount for example if the item cost $100 just add
25% of the initial cost to give me a new price of 125

Either can be handled with paste special. To add $25, type 25 in some blank
cell and copy (ctrl c). Highlight your old prices and Edit gt; Paste Special,
select Add and click OK.
To add, say 25%, type 1.25 (1 25%) in some blank cell and copy. This time
Edit gt; Paste Special, select Multiply and click OK.

quot;Jasonquot; wrote:

gt; I'm making a price list and Excel 2003 my cost is in the spreadsheet I would
gt; like to add an exact dollar amount to the cost how can I do this without
gt; retyping the entire number for each and everyone. For example in the current
gt; spreadsheet is listed at a certain item cost $100 I would like that to say
gt; $125 the problem is there's over 300 items and if I had to add $25 to each
gt; item I would have to retype each number all 300 I'm looking for a formula
gt; that I can use to add $25 and then just use to fill handle. Secondly I would
gt; like to also be able to do this by just adding a percentage of the original
gt; number instead of a dollar amount for example if the item cost $100 just add
gt; 25% of the initial cost to give me a new price of 125