We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or clicking another cell after getting the cell in edit-mode, the cell stopped showing the formula result and instead showed the formula.

e.g cell was showing "102". Double-click and it showed =100+2.

Can I enter a number from 1 to 20 in one cell and that same cell automatically multiply by $2.25 and give me the total

In Excel, I'm trying to write an IF function which will avoid a circular reference.
If cell X has a formula referencing this cell Y, display a value. Else if cell X has a value, divide that value by X

Cell X has Y*5.

Cell Y should display a value unless I change cell X to a value. Then it displays X/5.

Scenario 1

Cell X has =Y*5 and shows 10

Cell Y shows 2.

Suppose you have a workbook riddled with array formula.

In Excel 2007, if you select any cell (which is part of an array formula), then hit F2 to edit, you have to go ctrl+shift+enter to enter the formula (which already exists) as an array formula. When doing this, all the cells that are part of the array formula are selected (highlighted).

However, in Excel 2010, this behaviour is different.

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below.

However I want to add an additional function where popular values are automatically entered into that same cell(A4).

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells.

On the one hand, Excel recognizes tab-delimited text pasted from the clipboard as cells:

row 1 cell 1 row 1 cell 2
row 2 cell 1 row 2 cell 2

On the other hand, you can open an Excel XML text file that includes formatting.

Is it possible to get the

I want to be able to enter one date in one cell and then have the date read one year out in one cell, 11 months later in another I am using =DATE(YEAR(B4)+1,MONTH(B4),DAY(B4)) and it works great, but I need it to take the info from two cells.

So the date I enter will either be under date joined or date renewed. One date entered into one cell or another cell.

Since I can't create a form using VB or ACCESS here at work, I'm trying to figure out if I can use a cell as a makeshift form.

The intention behind this query is to simplify the review of excel sheets with engineering calculations.

Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 contains "Rra". Cell reference of cell B1 should be automatically renamed as "Rfa" (content in A1) and that of B2 as "Rra" (content in A2).