You are Here: Home >< A-levels

# Excel question watch

1. Hello, I was wondering if anybody could help me with an excel function. I want to have a cell for total cost and another cell where I could input a number and it add it to the total cell and then delete it from the cell I inputted. For example the total cell is £100 and I want to add £30 so I would add 30 to the cell it would delete and then later if I wanted to add £20 put 20 in the cell and it add to the total cell so the total cell would read £150. I hope I am explaining this well enough I just can't find any answers and I don't know if it is due to my poor wording, thank you.
2. (Original post by Joxh)
Hello, I was wondering if anybody could help me with an excel function. I want to have a cell for total cost and another cell where I could input a number and it add it to the total cell and then delete it from the cell I inputted. For example the total cell is £100 and I want to add £30 so I would add 30 to the cell it would delete and then later if I wanted to add £20 put 20 in the cell and it add to the total cell so the total cell would read £150. I hope I am explaining this well enough I just can't find any answers and I don't know if it is due to my poor wording, thank you.
Which version of Excel are you using?

A function like this would require you to create a macro (you could record a macro of you doing copy > paste special > values + add and then deleting the input value and then assign it to a key stroke or add a button).
3. (Original post by PQ)
Which version of Excel are you using?

A function like this would require you to create a macro (you could record a macro of you doing copy > paste special > values + add and then deleting the input value and then assign it to a key stroke or add a button).
I'm using excel 2013. I'll try this method tomorrow at Work, thanks for the suggestion

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: October 26, 2017
The home of Results and Clearing

### 2,979

people online now

### 1,567,000

students helped last year
Today on TSR

### University open days

1. SAE Institute
Animation, Audio, Film, Games, Music, Business, Web Further education
Thu, 16 Aug '18
2. Bournemouth University
Fri, 17 Aug '18
3. University of Bolton
Fri, 17 Aug '18
Poll

## All the essentials

### Student life: what to expect

What it's really like going to uni

### Essay expert

Learn to write like a pro with our ultimate essay guide.

### Create a study plan

Get your head around what you need to do and when with the study planner tool.

### Resources by subject

Everything from mind maps to class notes.

### Study tips from A* students

Students who got top grades in their A-levels share their secrets