PDA

View Full Version : Combine "if" formula : help required



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.

Bob Phillips
07-25-2012, 03:05 PM
=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
07-25-2012, 09:59 PM
Hi Xld,

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

Regards,
Satish Gubbi