Hi Tony
What do you actually want to calculate (in words)? When you say such
and such a column is 1/4 term, do you mean it is the balance outstandng
to be repaid one quarter thru the term, or is it simply the number of
months represented by the quarter term (ie for a 120 month term, this
would be 30)?
Are you sure you need to have all this listed down 5000-odd rows for
each term? It does seem like a rather horrendous duplication of effort?
Do you have need to have all of them held on the spreadsheet?
Best regards
Richard
TonyMorcom wrote:
Please help me someone.
I have a work book with 3 worksheets. 2 & 3 are complete and function
perfectly, more by trial and error than expertise.
Work sheet one is causing real problems:-
Assume the following info:
Column A Amount in £ individually from £500~£4999, duplicated by term.
Column B Term 180months,120,108,96,84,72,60,48,36 & 24.
Scenario is that for each amount in £ I need to have a term its over so
that i have entered the contents of the columns as follows
A1 500
A2 501
A3 502
etc down to
A4999
Against each row in Column B is the term so for 1st 4999 rows B shows
180, then the next 4999 B shows 120 etc)
Column C = relevant APR
Column D = relevant 1/4 term,
Column E = 1/2 term
Column F = 3/4 term.
There are a further 4 columns which are based on deferred payents
producing the corresponding values so that a formula will give a
true/false answer in figures as I have done on the other work sheets.
They were no real problem as each only the term was variable not the
amount.
I have the problem that I need to produce a formula which will generate
a result based on the entry of Amount and Term combining to give a
result from the following columns. Once I get one working I can get the
others working. Any help would be tremendously useful. Tony
--
TonyMorcom
------------------------------------------------------------------------
TonyMorcom's Profile: http://www.excelforum.com/member.php...o&userid=35056
View this thread: http://www.excelforum.com/showthread...hreadid=547987