satish gubbi
07-25-2012, 11:56 AM
Hi ,
I have below IF formulae which works as intended, I need this to be combined so that all three conditions get verfied on single cell reference.
=IF(P5="Monthly",IF(L5<40909,N5*BF2,(DATEDIF(L5,BE1,"m")*N5)))
=IF(P5="Qtr-Arr",IF(ROUNDUP(DATEDIF(L5,BE1,"m")/3,0)<=BH2,ROUNDUP((DATEDIF(L5,BE1,"m")/3)*N5,0),ROUNDUP(N2*BH3,0)))
=IF(P5="Qtr-Adv",IF(ROUNDUP(DATEDIF(L5,BE1,"m")/3,0)<=BI2,ROUNDUP((DATEDIF(L5,BE1,"m")/3)*N5,0),ROUNDUP(N5*BI2,0)))
Attached is the sample workbook for your reference.
I have below IF formulae which works as intended, I need this to be combined so that all three conditions get verfied on single cell reference.
=IF(P5="Monthly",IF(L5<40909,N5*BF2,(DATEDIF(L5,BE1,"m")*N5)))
=IF(P5="Qtr-Arr",IF(ROUNDUP(DATEDIF(L5,BE1,"m")/3,0)<=BH2,ROUNDUP((DATEDIF(L5,BE1,"m")/3)*N5,0),ROUNDUP(N2*BH3,0)))
=IF(P5="Qtr-Adv",IF(ROUNDUP(DATEDIF(L5,BE1,"m")/3,0)<=BI2,ROUNDUP((DATEDIF(L5,BE1,"m")/3)*N5,0),ROUNDUP(N5*BI2,0)))
Attached is the sample workbook for your reference.