I want to knw if there is a way to use excel to caluculate the total
amount of a loan once I have the interest rate, the numbers of months
of payments and the monthly payment amount.  for example I want to know
how much the loan would be if I paid 500 a month on a 30 year loan at

I am creating a custom header for financial statements.  It has 238
characters (without spaces) according to Word Count in Microsoft Word.  When
I hit enter in Excel to create the header, it says that headers must be less
than 255 characters in length.  

This code
Code:
--------------------
   =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

How do I delete formulas but save numbers?

I have a number in cell B1 that is a pasted link from a different worksheet.
I want the font color in cell B1 to change depending on what value is
displayed in B1. If <70 RED Bold, If 70 to 120 Automatic, If >120 Red Bold

I am putting together a list, and want to use validation features in most of
the Columns to limit choices for individuals to enter. My problem is that, a
choice for Column A, limits what choice you can use in Column B. For
instance, let's say Column A has two choices, "USA" or ...

Hello...
Is there a formula I can use to turn two columns of names (first & last)
that are currently in Capital letters, into small letters with only the first
letter in Caps?

I have this formula:
=SUMPRODUCT((Sheet1!$D$5:$D$96=Sheet3!E10)*(Sheet1!$F$5:$F$96=Sheet2!$D$21)*(Sheet1!$H$5:$H$96))
but when I make the range larger:
=SUMPRODUCT((Sheet1!$D$5:$D$800=Sheet3!E10)*(Sheet1!$F$5:$F$800=Sheet2!$D$21)*(Sheet1!$H$5:$H$800))

OK, here is another one.
I would like to combine the sheet name and a cell value to equal a ful
date. All in one cell.
I have the month and day part. That isn't a problem at all. For that,

I formula that identifies unique entries in a column and counts the
total as shown below:
=SUMPRODUCT(B8:B501<>"")/(COUNTIF(B8:B501,B8:B501&"")))
I am trying to get this formula to work only where a precondition

Excel 2003 Professional Edition.

Really hoping someone can help me on this one, as I have spent hours
trying to figure out and there must be a simple way to do it.
I have an invoice template, where the sales person enters the product
code into one cell and then the description then appears in the

I have this equation:
=SUMPRODUCT(--(Y$2:Y$80=Y83),--(Z$2:Z$80=Z83),--(AA$2:AA$80=AA83))
I want to modify it so that it will work only if AC$2:AC$80="ABC".   What do
I need to do?

I want to count the number of times a row has two specific words, in two
different cells eg.
If column A contains the word 'Widget' and column B contains the word 'Sale'
I want to count the number of times this occurs.

i have a spreadsheet of client names on one column phone on second column and
adresses on third column. i would love to set up address labels. any way to
do this?