I am using Excel 2002. In cell A1 I have a long formula, and in cell
A2 another long formula. How can I copy the formula in cell A2 and
then add the formula to cell A1 so it has its formula plus [+] the
formula in A2?

Simple query that's probably been asked a million times before so it might
be easier just to point me in the direction of a website that deals with
Excel functions for dimwits.
But my query is this....

Hello all...
I currently have this formula, which works fine...
=IF(A20="L",L20-H20,H20-L20)
however now what I want to do is add an if statement to same cell that

How do you get each Sheet Name in a Workbook so you can use it in code?  I
know that each Sheet, regardless of Name has an Index of 1 through n
beginning with the leftmost Sheet but I don't know how to use that
information.

I have a data set as follows:
ABC    Run    3
ABC    Walk    2
ABC    Sleep    5

Help. I need to know the formula to figure this out. I need the
formula for the cells with the question marks. Example: The total
Dances column would be 2 for Bill, 0 for Ann, 2 for Harry, 0 for
Walter. Then I need the other to columns filled in as well. I hope

A few days ago I noticed all my macros, that had been stored in Personal
Macro Workbook, had disappeared. What could be the reason?

I would like to modify an excel document that I send to my customers so that
when they open the file it comes up in a format ike the print preview and not
the working format. How to I do this?

On opening Excel I get on the RHS the list of recently-opened files
that is so useful in retrieving those files which I use frequently.  My
list is of 9 files - I guess that to be the default number.
   Occasionally I do some tidying up - maybe deleting, re-naming or

Office Excel 2007
Is there a way to find the average of column of figures EXCLUDING any row
that has a zero in it?
I have a column of figures. Each row corresponds to a day, and each day a

I am using MS Office 2003 EXCEL and have already tried to and installed
an EXCELff hotfix sent to me by Microsoft. The EXCELop file would not
install. This is all due to the following problem with EXCEL 2003:
When I attempt to open my EXCEL files with password protection on them I ...

Is there a way to use a built-in worksheet function, or defined name, to
refer to a worksheet name?
I'd like to fill a cell with the name of a worksheet, yet have the value in
that cell

How do we right justify a portion of the text entry in an Excel 2007
worksheet cell?  Right and left justify will shift all the text within a
cell to one side or the other.  However, other programs have an option for
'Flush Right' or 'Flush Right with Dot Leaders'.  This allows ...

I have a range of values. A1 - C1
For example A1 = John, B1 = Q., C1 = Customer
In cell D1 I enter =+A1 and get the value "John".
However, the next time I do this I get the result +A1.

Here in UK, banks seeking depositors must (for comparison purposes)
quote the AER (Annual Equivalent Rate) for each type of account they
offer.  So that although interest may be earned daily the AER tells us
what the accrued daily interest will total in a year's time.  Thus