Loan Amortization Schedule Formula
Sat, 11 Oct 2008 16:41:01 -0700
Does anyone know how I can set up a loan amortization for $15,000 at 5% for
10 years with monthly payments? I have tried a couple different things and
keep getting NAME? in columns for to interest and to principal. I have a
template but I would really like to know how to do the formula for this.
Formulas ...
|
saving a data item
Sat, 11 Oct 2008 16:25:00 -0700
How do I save the results of a cell so that when I restart the work sheet
will automatically reload that data value into a cell for reuse? I using
Excell 2000 at the moment. Thanks for your help.
--
Mike ...
|
Count number of times a text occurs
Sat, 11 Oct 2008 12:23:25 -0500
I want to count the number of times a text occurs in a range and then put
1,2,3,ect in a cell adjacent to the occurance.
Apple 1
Apple 2
Apple 3
Apple 4
Banana 1
Banana 2
Banana 3
I can use the count function but it doesn't seem to help with the numbering.
It seems like it should be simple but it probabl ...
|
Sr. Citizens Question, Please
Sat, 11 Oct 2008 10:24:44 -0400
Hello,
Embarrased to ask something so simple, but am in my 70's now, and haven't
used Excel in quite a whle.
Have a long column "A" of numbers.
Would like to create an adjacent column, B, with each number in the first
column A being divided by, e.g., 10.
(and showing up in this adjacent B column)
So ...
|
How do I set the default date
Sat, 11 Oct 2008 07:14:00 -0700
The help file says to set the date in Control Panel. My regional setting in
control panel shows the default date as 10/11/08 but when I enter in "10/11"
it is changed to "11-Oct" ...
|
What is meaning of $ in excel
Sat, 11 Oct 2008 00:40:00 -0700
Dear all
Plz help, what is meaning of $ in excel ...
|
New computer and office 2007
Fri, 10 Oct 2008 22:25:45 -0500
I ordered a new computer at work and already have office 2007. I want to
activate it on the new one and deactivate it on the old one. Has anyone done
this or what will I have to do? I did a search on Microsoft and didn't get
any hits on it.
Thanks,
Lee
...
|
|
|
error on a macro
Fri, 10 Oct 2008 08:26:01 -0700
I have created this macro to open an excel file; but if a file is not selected
than end up in error, is there a way to stop the macro without an error
this is what i have
Sub OpenWorkbok()
Dim fName As String
fName = Application.GetOpenFilename()
Workbooks.Open Filename:=fName
End Sub
...
|
Is It Possible????????????
Thu, 9 Oct 2008 20:53:01 -0700
What i would like to do is create a drop down box with codes #'s. Then when i
click on the code # the definition of the code would appear in the next cell.
Is that possible? ...
|
customize the page size
Thu, 9 Oct 2008 20:43:00 -0700
How to cutomize the page size for printing ? ...
|
