| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to take 1 column $ amount & put in another column - 2%
I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I started this I only had a hand full to change and I did this by going into each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to change to show the 2% off. That's 500 + rows. These has to be a better way. I have asked several people who work with excel and they could not help me and I also looked on line. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get last amount in a column | Excel Worksheet Functions | |||
| enter date in column a and amount in column d | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
| Insert Row When Column Amount Changes | Excel Discussion (Misc queries) | |||
| Insert New Row When Column Amount Changes | Excel Worksheet Functions | |||
Threaded Mode
