G
Guest
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
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