I do not have XIRR function to calculate IRR for my investments.  I
only deposit, do not withdraw, can someone help me with formula or
installing XIRR.
The formula others use:

I have a workbook containing many sheets. The first sheets are years ("2005",
"2006", "2007", "2008") followed by sheets for each individual project
("00387"..."00798"). The year sheets look up information from the project
sheets and this has not been a problem.

I am using a workload log spreadsheet to enter individual customers names
daily as requests come in. To avoid entering customers twice by accident i
would like to know if there is any way to enter a customers name in a
formula, which will then search a column within the log and ...

I am working on a schedule and I need to subtract 70 hours from the event
time.  If the event time is 1/10/08 06:20:44, when I subtract 70 hours, it
only subtracts 22 hours with the TIME function, hence calculating 1/9/08
08:20:44.  Is there some way to get Excel to automatically ...

In Book2 I have a named range "Employees".
In Book1 I have a list box.
In the Format Control option for my list box I select the Input Range area.
I have typed numerous variations of the following but I keep getting a

I just made a very    simple ledger that has 4 columns( descriptio, debit,
credit and balance) and I am just using one formula in balance column that is
=IF(AND(ISBLANK(D4),ISBLANK(E4)),"",F3-D4+E4)
basically it checks the debit and credit columns(D & E) if they are blank

I am looking for a formula that does not seem to exist within the
existing range.
I am an intermediate level user of Excel
I often use the SUMPRODUCT formula to calculate the product value from

How can I load a text cell with either english or French depending on what
language the user chose?

How do I make a formula for a time that starts at night, (23:30) and ends the
following day (09:00) and come out to be 12.5????  I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as 12.5.
I don't want to have to use a date along with the ...

I was looking for two formulas.  One if I have an APR, to be able to insert
that and get the APY.  Same thing in reverse...if i have an APY to input it
to get an APR.
thanks!

I have a problem !
In one spreadsheet I have in I152 a formula "I151+1", which formatted as a date gives me "30 nov 07" as a result.
In another spreadsheet I have an array where the same "30 nov 07" coming from a formula "Date(e6;11;30)" (where e6 = 2007), also formatted as a date.

I've recorded a macro that deletes a worksheet tab within a workbook, the
problems I'm having is once the macro is complete I get an excel message that
says "Data may exsist in the sheet selected for deletion. to permanently
delete the data, press Delete"  

When using the Vlookup statment on a cell where that cell content does not
exist in the vlookup range, how do you avoid the #NA or #value error?
I read previous posts and tried the ISNA formula but Excel will not accept
the formula- it stays at the change formula display.  The ...

I have a spreadsheet with different data in multiple columns.  Depending on
whether those columns have certain criteria i need to sum a different column.
         A                 B               C                    D          
    E

I have a huge database I'm working with where there will be many duplicates.
The duplicates need to be deleted. The criteria I am using is first and last
names as well as address. Thank you.