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 always use "Equation Object" in Microsoft Word, and I know that one can also insert such an object in Excel. However, the inserted Equation Object just "floats" on excel, it's not "inside" any cell.

Is there a way to put the Equation Object inside an Excel cell? so that sorting etc won't lose the information.

I am having an excel issue that I have never seen before:

I have a group of numbers, depending on which cell I "sum" the numbers from, excel either sums them correctly, or not.

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type value as *14-03-01 and changed the date format to DD-MM-YY. Now the date in the cell looks as per the selected date format. Now what I want is to use the same date format into formula bar too.

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.

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from the bill into one cell in a row, and have excel workout the amount for all the other intervals (four other cells in the row).

So I have an excel table that is multiply 1 value against several other values. It looks like this:

So I want the equations inside cells C14 to F14 to be B14*C5, B14*C6, B14*C7, B14*C8 respectively. So I can obviously do that manually but I want to learn the faster way. So I know I should use absolute reference for B14, so I can input =$B$14*C5 for cell C14.

See the following situation:

For some

Here cells A1:E3 have plain text data (no formulas), and C4:E4 have the same formula (i.e. typed in one cell and then autofilled to another ones).

I wanted to make cells C4:E4 contain __ if there's nothing in the two cells to the right of them in line 2, and average of 5 cells around corresponding cell in line 2 otherwise.

I would like to use repeat a formula with some constants noted in an assumption table how do I do so in Excel on a Mac. In Excel on a non Apple device the formula would be something like this =B3*(G$4$/A3).