Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys
can anyone explain to me what this formula is doing?
the formula: =IF(AND($C2=1,G2<>0),0,IF(AND($C2=1,MONTH($B2)&YEAR($B2)=MONTH(H$1)&YEAR(H$1)),$F2,IF(MONTH($A2)&YEAR($A2)=MONTH(H$1)&YEAR(H$1),$F2,IF(AND(RIGHT(H$1,4)&MID(H$1,4,2)&LEFT(H$1,2)>TEXT($D2,"YYYYMMDD"),RIGHT(H$1,4)&MID(H$1,4,2)&LEFT(H$1,2)<= TEXT($E2,"YYYYMMDD")),$F2,0))))
data below
<tbody>
</tbody>
the formula is typed in column H2 ( the output is 133 )
thank you for any help provided.
can anyone explain to me what this formula is doing?
the formula: =IF(AND($C2=1,G2<>0),0,IF(AND($C2=1,MONTH($B2)&YEAR($B2)=MONTH(H$1)&YEAR(H$1)),$F2,IF(MONTH($A2)&YEAR($A2)=MONTH(H$1)&YEAR(H$1),$F2,IF(AND(RIGHT(H$1,4)&MID(H$1,4,2)&LEFT(H$1,2)>TEXT($D2,"YYYYMMDD"),RIGHT(H$1,4)&MID(H$1,4,2)&LEFT(H$1,2)<= TEXT($E2,"YYYYMMDD")),$F2,0))))
data below
A | B | C | D | E | F | G | H | |
1 | Start Date | END DATE | LENTH | first date of Start | first date of END | per mth | 30/06/2016 | 31/07/2016 |
2 | 13/08/2015 | 12/08/2016 | 12 | 01/08/2015 | 31/07/2016 | 133.33 | 1466.63 | 133 |
<tbody>
</tbody>
the formula is typed in column H2 ( the output is 133 )
thank you for any help provided.