Combine "if" formula : help required

[satish gubbi]

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.

[Bob Phillips]

=IF(P5="Monthly",IF(L5<40909,N5*$BF$2,(DATEDIF(L5,$BE$1,"m")))*N5,
IF(P5="Qtr-Arr",IF(ROUNDUP(DATEDIF(L5,BE$1,"m")/3,0)<=BH2,ROUNDUP((DATEDIF(L5,BE$1,"m")/3)*N5,0),ROUNDUP(N2*BH$2,0)),
IF(P5="Qtr-Adv",IF(ROUNDUP(DATEDIF(L5,BE$1,"m")/3,0)<=BI1,ROUNDUP((DATEDIF(L5,BE$1,"m")/3)*N5,0),ROUNDUP(N4*BI$2,0)))))

[satish gubbi]

Hi Xld,

Thank you very much for your help, this working as intended

Regards,
Satish Gubbi