I am getting this error when using the 97 compatible file format.

Kindly tell me whether there is any formula or readymade function to find out
the number of years required to depreciate an asset fully ( minimum value $
1)using a declining balance method.  For example, if my asset is worth $ 1000
now and it has to be depreciated at 10% / year i ...

my data validation list sometimes starts at the bottom vs top of list how do
I set that it always starts at top of list?  does a way exist that user can
start to type item in list and it will find it and populate.

Hi, I have this formula which is half working. I need it to say first of all
If cell AN="AIR" and the AX="Fri" then add 3 days to AJ. if AX = "sat" &
AN="air" add 2 days to AJ. Otherwise if AN = "air" and the AX is any of the
days not mentioned above add 1 to AJ. After that if AN ...

Update Validation Selection I have been to www.contextures.com and downloaded
DV0022, this is exactly what I wish to achieve when a selection in the list
is updated the data file updates to the new description.  The problem is when
I add a new item to the list it updates every ...

I´d like to "compact" the following column in a single cell value
using array formulas, if that is possible.
The columa A is filled with results of a certain function, and column
B has the Pearson correlation of that column in this way.

I have a spreadsheet where, in one column there is a number. The next column
holds a list of random numbers. I want the sheet to look at the number in the
first column and then select that number of entries from the random number
column to use.

How would I change the below formula to say "NO" if row A had an "X" placed
in that cell.
=IF(OR(AND(L2>=7,L2<=100),AND(M2>=1,M2<=100)),"YES","")

According to http://office.microsoft.com/en-us/excel/HP052038731033.aspx 
degrees of freedom in t-test for two unequal variances (regardless of using
TTEST or t-test from toolpak) uses a formula where
(S1^2+S2^2)^2(((S1^2/m)^2/m-1))+((S2^2/n)^2/(n-1))) = DF (call this formula

Is there anyway to link a comment to a cell?
e.g. if cell A1 says "hello", I want the comment in cell B1 to say "hello",
linked to the content of cell A1?
Thanks in advance.

I have the following dates:
31/03/2007
30/10/2006
09/12/1991

number,x, from cell A3 and a positive  integer, n, from cell B3 then
returns into cell C3 the value of x raised to the power n divided by
n factorial.
where x in cell a3 =  2 and n in cell b3 = 5

I only want to print horizontal gridlines in excel for a project. How should
I do so?

Is it possible to extract the filtered result after using the
AutoFilter and use this list to be the filter criteria on another
worksheet.
So for example:

I have a results workbook that uses a VLOOKUP function to return text from
another source workbook. As long as the source workbook is open then the
formula works correctly, but if it is closed then the returned text is
truncated to 255 characters. Open the source workbook again ...