answersLogoWhite

0

There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What happens if you type a formula in a table column?

excel sums the cells in the column


Where can you get a list of Microsoft Excel column formulas?

There are no column formulas in Excel. Only formulas you put in individual cells. The closest thing to a column formula would be VLOOKUP.


What is the address of 255 column in Excel?

Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.


What is column break in Microsoft Excel?

A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.


How do you insert rows in Excel 2007 past IV?

Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.


What excel formula can be used to calculate FICA?

If the employee's gross pay is in column A, line 1, and you want the FICA deduction in column B, then the formula in B1 is A1*.0765


When Excel automatically fills the rest of a table column with a formula entered into an empty table column this is referred to as an column a calculated b autofilled c custom d concatenated?

Autofilled.


In excel what is the correct formula to auto sum column B?

If you have numbers in cells B1 through B134, use the formula: =SUM(B1:B134). You can use auto sum to insert the formula by highlighting the column (you can click on the column letter) and clicking the AutoSum button on the menu.


In Microsoft Excel what automatically resizes the column to fit the width of the columns contents?

In Microsoft Excel, double-click on the line that separates the column labels (the letters at the top of the spreadsheet). The column will resize to fit the contents of the widest value in that column. This usually works unless the contents of the cell are the result of a formula.


What is the last column letter in Excel 2010?

That depends on the version. Up to version 2003, it was row 65,536. From Excel 2007 onwards, it is row 1,048,576.


Which is the column separator in excel?

column margin


Where do the column headings begin and end in Excel?

Column headings start at A. After reaching Z, the next is AA, then AB and so on. What the last column is will depend on the version of Excel that you have. Column IV, which is the 256th column, is in the versions up to Excel 2003. From Excel 2007 there are 16,384 columns and last one is column XFD.