Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys
I am trying to fix a formula that i have no idea what it is doing.
the formula is
IF(DATEVALUE(F1)-TRIM(D2)>=0,J11040,IF(DATEVALUE(F1)-TRIM(C2)>0,DATEDIF(C2,F1+30,"m")*E2,0))
below is the data
<tbody>
</tbody>
The formula is placed in F1 and its suppose to return some number .
Can any one help explaining what this formula is doing and why is this not working?
Thank you
I am trying to fix a formula that i have no idea what it is doing.
the formula is
IF(DATEVALUE(F1)-TRIM(D2)>=0,J11040,IF(DATEVALUE(F1)-TRIM(C2)>0,DATEDIF(C2,F1+30,"m")*E2,0))
below is the data
A | B | C | D | E | F | |
1 | total | month number | start | end | per month | 30/04/2016 |
2 | 54.95 | 1 | 01/04/2016 | 30/04/2016 | 54.95 |
<tbody>
</tbody>
The formula is placed in F1 and its suppose to return some number .
Can any one help explaining what this formula is doing and why is this not working?
Thank you