Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    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.
    • Very Important Poster
    • PS Reviewer
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    Very Important Poster
    PS Reviewer
    Clearing and Applications Advisor
    (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).
    • Thread Starter
    Offline

    2
    ReputationRep:
    (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
 
 
 
The home of Results and Clearing

2,979

people online now

1,567,000

students helped last year

University open days

  1. SAE Institute
    Animation, Audio, Film, Games, Music, Business, Web Further education
    Thu, 16 Aug '18
  2. Bournemouth University
    Clearing Open Day Undergraduate
    Fri, 17 Aug '18
  3. University of Bolton
    Undergraduate Open Day Undergraduate
    Fri, 17 Aug '18
Poll
Do you want your parents to be with you when you collect your A-level results?
Help with your A-levels

All the essentials

The adventure begins mug

Student life: what to expect

What it's really like going to uni

Rosette

Essay expert

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

Uni match

Uni match

Our tool will help you find the perfect course for you

Study planner

Create a study plan

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

Study planner

Resources by subject

Everything from mind maps to class notes.

Hands typing

Degrees without fees

Discover more about degree-level apprenticeships.

A student doing homework

Study tips from A* students

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

Study help links and info

Can you help? Study help unanswered threadsRules and posting guidelines

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.