Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i sum dollars & cents in different columns | Excel Worksheet Functions | |||
Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) | |||
Separating dollars and cents | Excel Worksheet Functions | |||
converting #dollars into word dollars? | Excel Worksheet Functions |