| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 23834 | 2002-08-27 03:19:00 | Microsoft Excel | Kwakers (1647) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 74147 | 2002-08-27 03:19:00 | I receive regular prices from suppliers in excel, I would like to highlight the columns of prices and apply a formula that would increase each cell by a percentage (to show a retail price), it would save heaps of time wasted by using a calculator for each items price increase. | Kwakers (1647) | ||
| 74148 | 2002-08-27 03:39:00 | Hi Kwakers, theres lots of ways do this but you probably want to keep the original price received from suppliers then have another column with your retail amount entered. A simple formula like = a1*1.25 where a1 is the cell with the amount and 1.25 means 25% above suppliers value. Is this the sort of thing you are meaning? |
parry (27) | ||
| 74149 | 2002-08-27 03:54:00 | There are many ways but I would do this by; 1. Head up the next column - type in row 1, "RETAIL @" This is just a heading - you can adjust the column width by positioning the cursor over the bar on the rh side and dragging until column is a useful width. 2. In row 2 put your % markup as a percentage eg type 22.5% This is you % value markup. 3. in row3 (or first row of data) type an "=" will open a function in the input field above the column headings 4. type "(1+" 5. Click on the cell containing your cost price and the Row/Col reference will be inserted in the function 6. TYpe ")*" 7. Click on the cell you inserted your markup percentage in row 2 and press "F4" Key - the cell reference will now show as $x$y where x and y are the column and row co-ordinates. 8. Press enter and the cell should contain your sale price. 9. Make sure the cell is highlighted and choose EDIT and COPY 10. Highlight teh column alongside your Cost prices and press EDIT and PASTE Your sale prices should be listed for you. If you change the % cell, it will be reflected in all the sale pricces. Hope this is not teaching grandma how to suck eggs but it seems a simple answer to me.. There are formatting things that can enhance redadability - turn on the helper and it can give you instructions. |
stumpey (190) | ||
| 74150 | 2002-08-27 05:34:00 | LOAD OF RUBBISH - Note to self: engage brain before offering opinions :8) Parry's solution is simpler and less prone to error. Formula should look more like CostPriceCell * (1+percentmarkup) or say "=D3*(1+$E$2)" Worth a bit of a fiddle with the Office Helper active - will lead you to try various options. Spreadsheets are great even without using fancy bells and whistles. Warning tho, check a few examples with a calculator before committing to use of information - errors can creep in. |
stumpey (190) | ||
| 74151 | 2002-08-27 10:35:00 | If anyone is interested, HP is currently running a free Advanced Excel online course which I am finding very good. Although two lessons have already been posted it's not too late to enrol and start. Check it out and enrol here (http://www.hplearningcenter.com/). There is also an Excel beginners course starting soon and there are other miscellaneous courses as well. |
Susan B (19) | ||
| 1 | |||||