I hope my grid below looks OK once it is posted.  I need a formula to
solve for cell G3.  I need a single cell formula to solve for the
total value of a commercial lease given the initial annual rent, the
rent increase percentage and how often (in years) that the rent is

How can I make field A2 = AA2 when it's not a number?
=SUM(AA2) displays a zero.

I have 2 reports of data both formatted the same and what I need to work
out are the differences between the two and just display those.
e.g Report 1 has for example A, B, D, F, G displayed and Report 2 has
A,B,C,D,E,F,G,H and what I want to see as an output is just C,E,H. can

I'm running Excel from Office 2004 for the Mac. Fairly frequently, the
formula bar gets "scrunched up" so I can't read the bottom line if I have
more than one line. I can fix this temporarily by selecting VIEW>FORMULA
BAR, to turn it off, then I turn it on again. But the problem ...

Is it possible to put totals in a header or footer? I haven't seen any place
that says you can or can't. If you can, then how?
Thanks,

Is there a way in Excel 2003 to print out the names of all the
worksheets in my workbook?
Thank your for your help
Joanne

I have one Excel worksheet with one column of personal names on it. I have a
2nd Excel worksheet that has several columns of personal names on it. I need
to compare the 1st worksheet to the 2nd worksheet for any misspellings.
(Microsoft Excel Office Edition 2003 SP2)

I want to be able to enter a function in one cell as a text string and
be able to use that function in another cell.
For example, I would enter the string "%CELL% - MIN(%RANGE%)" into
B1.  The cells B2 - B5 would replace the phrase %CELL% with their

Really needs someones help urgently. I am sure some one has come
accross this. I have autofilter on for " LEVEL" and in the column
"MARKET MATCH"  I want to copy-paste  a value (which is text ) for
those that meet the criteria in the autofilter. So for only rows

Can someone please help me.
I have 4 cells. One of the cells needs to be a quotient of the value entered
divided by 60. Then the product of all 4 cells.
Please help!!!!

I am trying to use GetPivotdata to sum the data in a range
The current pivotable displays the data with the weeks as Cols, and
Department/Year as Rows
I can use the following forumla to get the sales for a particular

Could anyone help? How to open new excel file in new window by
default? it opens in the last window on the screen as of now.
Bests
Jayesh

I have several Excel files that use a custom D/T format.  Issue is
when used by regions where they prefer a different format (d/m/y vs.
standard US m/d/y).
Instead of keeping two versions of each report, is there a way to

This free to use excel add in changes text to lower, upper and proper
case.
http://exceltemplates.blogspot.com/2007/09/microsoft-excel-change-case.html

If you want to change case in Microsoft Excel at a click of a button
without inserting any formulas just try this add in
http://exceltemplates.blogspot.com/2007/09/microsoft-excel-change-case.html