answersLogoWhite

0

The short answer is that you can not, but there is a solution that will work for you. You are not able to automatically insert data into a cell from another cell; that would be a push of data, which Excel does not do. However, Excel can pull data from a cell.

  1. Put your formula in a cell. Use A1 for this example.
  2. Write another formula in the target cell to reference the value of A1. Use B1 for this example.
  3. In B1, put the formula, =A1 to show the value of A1 in B1.

****this is not going to work for my prob dude.. check out discussion tab for more about my question, please. Please, please... please. :) need more help..

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the nested formula of MS Excel?

A nested formula is where one or more functions are placed inside another function to make a formula. For example you can write a formula where you put an IF function within an IF function and this would be a nested formula.


How many functions can be nested with the same formula in MS Excel?

Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting


An If function within an if function in Excel is called what?

A nested if.


What is a nested table in Excel?

It is a table inside another table.


What term is used to describe joining two or more functions into super function in Excel?

If one function is inside another, then the functions are nested.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


How do you use a if function in Excel on another cell with a nested if function?

i would need a little more information to be specific to your need, however the general way is =if(A1=2,"True value","False value",if(A1=3,"True Value","False Value)) you can continue the formula till you done with your conditions, however excel 2003 can only nest 7 level and Excel 2007 has no limits


What is a rule in excel?

it is a formula


Formula for the calculation of gratuity?

Excel Arrears calculation Only Formula Download Excel Arrears calculation Only Formula Download but free download Excel Arrears calculation Only Formula Download but free download not option