Formula help

[Jemma Atkinson]

Hi, i am after a single formula that will return the highlighted figures in col G, i want to avoid using the formulas in E, F and H just to get to G.

The below screen dump will help provide the various ranges used just to get to the desired result

Excel Workbook
	D	E	F	G	H
2	Last Run Date	20-Feb-11
3	Current Run Date	20-Mar-11
4
5	Transaction Date	Age Transaction date	Days Between	Days subject to Interest	Current Run - Last Run day
26	10-Feb-11	38	10	10	28
27	19-Jan-11	60	32	28	28
28	16-Dec-10	94	66	28	28
29	26-Nov-10	114	86	28	28
30	18-Feb-11	30	2	2	28
Sheet1

 

[zilch4ry]

=vlookup(A1,D5:H30,4,FALSE)

something like that?

 

[Jemma Atkinson]

=vlookup(A1,D5:H30,4,FALSE)

something like that?

Nope, re-read my question. I have used various helper formulas just to get to the result i want in Col g, i want one single formula to return this so i dont have to use the formulas in the other columns.

 

[Haseeb Avarakkan]

Hello,

Try this in G26, copy down...

=MIN(($E$3-D26)-($E$3-$E$2),$E$3-$E$2)

 

[Jemma Atkinson]

Hello,

Try this in G26, copy down...

=MIN(($E$3-D26)-($E$3-$E$2),$E$3-$E$2)

Spot on thanks.

 

[Dryver14]

2 days late as usual but its got me blood on now so

=IF($E$3-D6>$E$3-$E$2,IF(($E$3-D6)-($E$3-$E$2)<$E$3-$E$2,($E$3-D6)-($E$3-$E$2),$E$3-$E$2))