Forum menu
I’m having to do a fair bit of excel as I can’t work in the office. I can’t really use it to any skilled level but I’m happy to chip in.
How do I give the items in Column A a value so it automatically updates Column B total in the example below or what’s the term called so I can look on you tube.
KitKat 50p 3
Mars 70p 2
Chomp 20p 4
Total £3.70
Is this question as simple as wanting to know how to use formulas?
Say you put KitKat, Mars, Chomp in column A
Then in column B put the price per item
Then in column C put the no of items
Simplest would then be to write =B1*C1 in the cell D1.
Drag the bottom right of that cell to fill it down your list
Then at the bottom put a total by entering =sum(D1:D3)
You can hide columns you don't want to see. There are probably fancier ways to do this, but then it will be a total PITA to debug when something is broken.
(oh and if you've tried that - possibly you are getting issues with inputting values in p and wanting an answer in £ - best to stick to £ - and if you tell excel its a currency value (click the coins icon on toolbar) it will format it nicely for you)
The problem here is that your workplace isn't providing basic training you've got three separate data items in one field. You need to split them out first. This is Excel, not Notepad.
The easy way is to import your data sensibly in the first place. The harder way is to do it through Excel:
https://support.office.com/en-gb/article/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23
... because if you value-separate based on 'space' it will break as soon as you hit "Monster Munch" and at that point you're looking at string handling which could get messy fast. Might even need to crack out VBA.
Then do what Poly said.
NOBODY will look past the chomp, so save yourself the effort
I know how to do basic formula. I’ll look into hiding the Column. I’ve seen some spreadsheets where it know the value of Column A although perhaps they were using hidden columns. There are some excel gurus at work but they are busy doing proper work, I’ll ask about some training but it’s not my area.
Actually your way probably is way more user friendly as prices change.
NOBODY will look past the chomp, so save yourself the effort
Chomps had their day once they got more expensive than two Highland toffee bars.
Chomp removes the trailing newlines unless you're in slurp mode.