VBA or IF problem

[jhonatanbenami]

Here is my data:

A	B	C	D	E	F	G
application number	application number start date	task name	ID	task start date	task end date	application number End date
6256372	16/07/2014	missing/false documents	63298632	19/01/2016	19/01/2016	26/01/2016
6256372	16/07/2014	cash request	63298632	03/01/2016	20/01/2016	26/01/2016
6715072	08/01/2015	missing/false documents	314019381	28/10/2015	21/01/2016	25/01/2016
6867668	19/02/2015	missing/false documents	16534356	25/02/2016	29/02/2016	01/03/2016
6867668	19/02/2015	waiting for missing documents	16534356	19/07/2015	25/08/2015	01/03/2016
6867668	19/02/2015	missing/false documents	16534356	12/07/2015	19/07/2015	01/03/2016
6976458	22/03/2015	cash request	50649391	08/02/2016	09/02/2016	15/02/2016
7164340	11/05/2015	waiting for missing documents	57208340	11/05/2015	26/08/2015	03/01/2016
7259512	09/06/2015	waiting for missing documents	13195672	04/01/2016	21/02/2016	23/02/2016
7421034	04/08/2015	waiting for missing documents	24888638	04/08/2015	02/09/2015	11/01/2016
7483311	27/08/2015	missing/false documents	1754621	04/01/2016	05/01/2016	10/01/2016
7505991	06/09/2015	missing/false documents	17274630	05/01/2016	17/03/2016	12/04/2016

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

i need to find the time it takes to deal with application ,

the conditions are like this:
if (G3-B3)<=90
then application time is the result of : application number End date - application number start date

but if
(G3-B3)>90

then the calculation should be the

application number End date for task name "missing / false documents" or for task name " waiting for missing documents" ( i have to pick one of them according to the latest) minus task end date thank you! <tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[oldbrewer]

6976458

22/03/2015

cash request

50649391

08/02/2016

09/02/2016

15/02/2016

<tbody>
</tbody>

how is the application for a cash request 22/3/15 then 8/2/16 and 9/2/16 and 15/2/16

 

[jhonatanbenami]

there has been an error while copying :

here is correct line for it:

A	B	C	D	E	F	G
application number	application number start date	task name	ID	task start date	taske end date	application number End date
6976458	22/03/2015	cash request	50649391	08/02/2016	09/02/2016	15/04/2016

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

an application can have different tasks....

 

[oldbrewer]

sorry - I do not understand what you want - is application number a customer number ?

 

[jhonatanbenami]

you can refer to it like a customer number

 

[oldbrewer]

customer	date requested	task name	customer ID	task start date	task end date	confirmed as COMPLETE	TIME
6256372	16/07/2014	missing/false documents	63298632	19/01/2016	19/01/2016	26/01/2016	7
6256372	16/07/2014	cash request	63298632	03/01/2016	20/01/2016	26/01/2016	6
6715072	08/01/2015	missing/false documents	314019381	28/10/2015	21/01/2016	25/01/2016	4
6867668	19/02/2015	missing/false documents	16534356	25/02/2016	29/02/2016	01/03/2016	1
6867668	19/02/2015	waiting for missing documents	16534356	19/07/2015	25/08/2015	01/03/2016	189
6867668	19/02/2015	missing/false documents	16534356	12/07/2015	19/07/2015	01/03/2016	226
6976458	22/03/2015	cash request	50649391	08/02/2016	09/02/2016	15/04/2016	66
7164340	11/05/2015	waiting for missing documents	57208340	11/05/2015	26/08/2015	03/01/2016	130
7259512	09/06/2015	waiting for missing documents	13195672	04/01/2016	21/02/2016	23/02/2016	2
7421034	04/08/2015	waiting for missing documents	24888638	04/08/2015	02/09/2015	11/01/2016	131
7483311	27/08/2015	missing/false documents	1754621	04/01/2016	05/01/2016	10/01/2016	5
7505991	06/09/2015	missing/false documents	17274630	05/01/2016	17/03/2016	12/04/2016	26
		are these the answers you are looking for in the last column

<colgroup><col><col><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[jhonatanbenami]

Yes!

 

[jhonatanbenami]

would you mind sharing the knowledge ?

 

[oldbrewer]

for the first answer the formula I used was =if(g3-b3<=90,g3-b3,g3-f3)