IF(F8>0,(IF($F$12="Acc Bi-Weekly",ROUND((-PMT((((1+Amortize!F7/CP)^(CP/12))-1),term*12,loan_amount))/2,2),IF($F$12="Acc Weekly",ROUND((-PMT((((1+Amortize!F7/CP)^(CP/12))-1),term*12,loan_amount))/4,2),ROUND(-PMT(((1+F7/CP)^(CP/periods_per_year))-1,nper,loan_amount),2)))),0)

Thanks,

SKK