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.

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).

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 need a formula in excel, to copy and display a value from cell A1 to B1, if cell A1 value is changed from a positive value to zero, the value in cell B1 must not change, it must retain its previous value(which is always greater than zero).
The value are numbers.

Regards,
Kailash

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 am creating a weekly income comparison table. I want to compare A5 and A10 cells and display appropriate image in B7 cell. The image will be either UP or DOWN arrow (which reflects increase or decrease).

I've created a formula which puts text up or down in the cell, but I don't know how to replace it with the up/down image.

=IF(D77>D69, "up", IF(D77<D69, "down"))

How can I do it?

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).