A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

table



 
 
Thread Tools Display Modes
  #1  
Old January 11th, 2005, 05:17 PM
dow
external usenet poster
 
Posts: n/a
Default table

I need help making a table in Excel 2000. I want to make a table in a
worksheet (sheet 2) that incorporates numbers (calculation 1 & caculation 2)
that are calculated in another worksheet (worksheet 1) in the same workbook.
The 1st column of the table contains a list of numbers (loan amounts). The
2nd and 3rd columns are to contain numbers (calculation 1 & calculation 2)
that correspond to the loan amounts in the 1st column. Worksheet 1 is a
modified loan amortization calculator. Calculation 1 & calculation 2 are
specific to the loan amount entered. In the table, the 1st cell of the 1st
column will be 10,000 and increase by 5,000 increments. When I enter a loan
amount in the calculator (worksheet 1), I want calculation 1 & 2 to be placed
in the 2nd & 3rd columns of the table and in the row that corresponds to to
the loan amount entered in the calculator.
For example: in the table, the 1st row will have 10,000 in the 1st column.
When 10,000 is entered in the calculator, calculation 1 & calculation 2 would
be entered in columns 2 & 3 of the 1st row. The 2nd row of the table will
have 15,000 in the 1st column. When 15,000 is entered in the calculator,
calculation 1 & calculation 2 for that amount would be entered in column 2 &
3 of the 2nd row, and so on down the table.
I will be making 8 separate tables. Each table will have the same loan
amounts in column 1. Calculation 1 & 2 will be different because a different
interest rate will be used.
Thank you for your help.
--
dow
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate data Rob Green Database Design 3 November 7th, 2004 03:08 AM
Access & OleDb - generating schema changes, problem with identity/counter fields. Thomas Tomiczek [MVP] Database Design 9 November 5th, 2004 10:32 AM
Automatic filling of fields in table two from table one Jim Kelly Database Design 1 September 27th, 2004 10:16 PM
Autonumber Ally H. General Discussion 7 August 27th, 2004 04:51 PM
Name not showing ID is René Setting Up & Running Reports 11 June 29th, 2004 01:40 AM


All times are GMT +1. The time now is 02:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.