Soldato
- Joined
- 28 Oct 2011
- Posts
- 8,778
Can someone please help???
New job and they've just plonked this on me and I can't do it, I've been trying for hours. I got the formulas to work a bit but as soon as try adding headings and spaces it all ****s up. Also my copy of excel at home does not behave the same as my work copy...
It's 4 columns. Here's an example set out.
ITEM NAME COST PRICE MARKUP QUOTE PRICE
EMPTY ROW OF CELLS>>>>>>>>>>>>>>>
WINE £1.00 £0.35 £1.35
BEER £2.00 £0.70 £2.70
Right, the markup needed to be added to cost price is always 35% so 'MARKUP' Column will show £0.35 for ex and £0.70 for ex. The fourth column will show the final price ie £1.35 and £2.70 as shown in table (sorry for the over explanation).
If someone would be kind enough to knock me this spreadsheet up if not for tomorrow AM then any time tomorrow I would be eternally grateful.
Thanks in advance.
New job and they've just plonked this on me and I can't do it, I've been trying for hours. I got the formulas to work a bit but as soon as try adding headings and spaces it all ****s up. Also my copy of excel at home does not behave the same as my work copy...
It's 4 columns. Here's an example set out.
ITEM NAME COST PRICE MARKUP QUOTE PRICE
EMPTY ROW OF CELLS>>>>>>>>>>>>>>>
WINE £1.00 £0.35 £1.35
BEER £2.00 £0.70 £2.70
Right, the markup needed to be added to cost price is always 35% so 'MARKUP' Column will show £0.35 for ex and £0.70 for ex. The fourth column will show the final price ie £1.35 and £2.70 as shown in table (sorry for the over explanation).
If someone would be kind enough to knock me this spreadsheet up if not for tomorrow AM then any time tomorrow I would be eternally grateful.
Thanks in advance.