gooodee asked:
Column A is retail $ I need to take 25% off A and put $ answer in column B for wholesale prices for about 6000 parts.
A-25%=B for 6000 rows
Column A is retail $ I need to take 25% off A and put $ answer in column B for wholesale prices for about 6000 parts.
A-25%=B for 6000 rows
October 27th, 2009 at 22:49
Sounds like your homework.
October 28th, 2009 at 23:13
It’s very simple if you’re doing this in MS Excel.
Let’s say column A, row 1 (or cell A1) retail $ = 100. Then in column B, row 1 (or cell B1), the formula should read =(A1*0.75). The result in B1 should be $75.
If you need to copy the formula for about 6,000 row, then simply:
1.) highlight cell B1
2.) click Edit, Copy from the toolbar
3.) arrow down to cell B2, press down on the “Shift” key and page down (pressing the “Shift” key and “Page Down” key simultaneousl) until you get to row 6,000, then click Edit, Paste from the toolbar
Hope that helps.