I have a formula in a worksheet provided by others. I’d like assistance to clean it up. I no longer need to include reference to a couple options – “Acc Weekly” and “Acc Bi-Weekly”. I like to remove reference to both of these in the following formula.
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
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