D
driller
Hi All,
TIA...
I need to extract the corresponding intercept of the days with the amount.
for cash flow variance
e.g.
I have one row with 10 columns - each cell contains days -
A2:J2
25 50 65 90 115 135 150 180 200 215
then I have a 2 columns of data
first column stores the amount, while the second column stores the days...
A10:B20
$30,000 30
$60,000 60
$90,000 90
$100,000 121
$150,000 152
$160,000 180
$200,000 210
$220,000 241
$250,000 271
$300,000 302
to place formulated result in A3:J3, by searching the direct interpolated
amount between the given data
e.g.
since A2=25 and A10=$30,000 and B10=30, hence A3=25,000
also since B2=50 then B3= $50,000
hope there is one formula for this type of question.
regards n gracias
TIA...
I need to extract the corresponding intercept of the days with the amount.
for cash flow variance
e.g.
I have one row with 10 columns - each cell contains days -
A2:J2
25 50 65 90 115 135 150 180 200 215
then I have a 2 columns of data
first column stores the amount, while the second column stores the days...
A10:B20
$30,000 30
$60,000 60
$90,000 90
$100,000 121
$150,000 152
$160,000 180
$200,000 210
$220,000 241
$250,000 271
$300,000 302
to place formulated result in A3:J3, by searching the direct interpolated
amount between the given data
e.g.
since A2=25 and A10=$30,000 and B10=30, hence A3=25,000
also since B2=50 then B3= $50,000
hope there is one formula for this type of question.
regards n gracias