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