formula help

[Imran Azam]

HI guys

i been given a spreadsheet at work and there is a formula that i dont understand

the formula is =IF(DATEVALUE(E$1)-TRIM(A2)>=0,B2,IF(DATEVALUE(E$1)-TRIM(C2)>0,DATEDIF(C2,E$1+30,"m")*D2,0))

the data s below

1	A	B	C	D	E
2	end date	price	start date	per month	30/06/2016
3	31/12/2015	4498.16	01/102015	1499.39	4498

<tbody>
</tbody>

the formula is in E3 and the output is in bold.

Can anyone explain to me what this formula is doing?

Thank you

Regards

Imran

 

[yky]

If the date in E1 (30/06/2016) is same as or after the end date (A2, 31/12/2015), then put B2 (4498.16) in E2, else if the Date in E1 is after the start date (C2) (and before the end date), then multiply D2 (1499.39) by the complete months between E1 and C2 and put the result in E2.

Btw, I think what you called E3 is actually E2.