Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by Anonymous on November 12th, 2009

Anonymous

Question

Help answer this question below.

Asalamo alikum. Respect sir. i want to add two cell i.e A1 & B1 but the result should be in B1 cell.and every old value of B1 should remain the same while it should be calculated with A1. i hope u will have understand my this problem. i will have bee

This question references this URL.
  • Like
  • Report
Share:
Other

Answers. 4 helpful answers below.

  • by Cyanotic Wasp on November 13th, 2009

    Cyanotic Wasp

    As others have also responded, you cannot enter the formula =A1 + B1 into cell B1 (or A1). Doing so will give you a Circular Reference error. So the thing that you propose will not work, as proposed.

    But if you give us some additional detail to work with, or an explanation of exactly what purpose you are trying to achieve, perhaps we can offer a workable solution. For example, attempting to retain "every old value of B1" in a single cell is impractical (there actually IS a way to approximate this, but it's not a very useful one, and could never be used in calculation). So if you'll consider sharing some ideas about the application you have in mind, I'm confident that there's "a way" to find something satisfactory.

    No comments. Post one | Permalink

  • by spock's brain on November 13th, 2009

    spock's brain

    Allikum asalam.

    If I understand, assuming that the value of B1 before adding is known and fixed, you would simply enter the known value and add A1 e.g. =X+a1

    I am a bit confused however by wishing the B1 value to remain the same "while it is being calculated" as this is instantaneous.

    If you want the calculation to take place only after neccesary data has been entered which will deterine the value of A1 or B1, you can use IF funtions.

    Not understanding what you want to do I can't comment but if you lok up IF functions in Excel help you will figure it out yourself.

    No comments. Post one | Permalink

  • by Seanzie is smiling again on November 13th, 2009

    Seanzie is smiling again

    You can insert a cell to the left of that you added?

    No comments. Post one | Permalink

  • by Brian I on November 13th, 2009

    Brian I

    I'm afraid that is impossible, you'll have to use C1. Even then you won't be able to include previous values of B1.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading Asalamo alikum. Respect sir. i want to add two cell i.e A1 & B1 but the result should be in B1 cell.and every old value of B1 should remain the same while it should be calculated with A1. i hope u will have understand my this problem. i will have bee

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Thinking about aliens
Asalamoalikum letter
Asalamo alikum

Answerbag

a Demand Media company