[Alex McQuaid]

I've made an attempt to understand and to convert formulas from my Excel application to the BlackBerry application that I'm working on, but I need input from someone with expertise in this area, to show me what I'm doing wrong.

Your assistance would be greatly appreciated. Thanks!!


(1) Excel Formula: =ROUND((1+PMIF)^12-1,4);
BB Formula: = MathUtilities.Round(1+PMIF),MathUtilities.Pow(12-1,4);


(2) Excel Formula: =((1+(AIR/2))^2)^(1/12)-1;
BB Formula: = (1+(AIR/2)), MathUtilities.Pow( ????.........


(3) Excel Formula: =(P*PIFM)/(1-(1+PIFM)^(-AMMO))..
BB Formula: = (P*PIFM)/(1-(1+PIFM), MathUtilities.Pow(-AMMO));

(4) Excel Formula: =ROUND(PPM,2);
BB Formula: = MathUtilities.Round(PPM,2);

[hrbuckley]

Well, MathUtilities.round() only takes one argument; MathUtilities.pow() requires two arguments . . .

I would suggest:
(1) Excel Formula: =ROUND((1+PMIF)^12-1,4);
IIRC the second argument to ROUND is the number of decimal palces

(float)MathUtilities.round( (MathUtilities.pow(1+PMIF,12)-1) * 10000 ) / 10000;

(2) Excel Formula: =((1+(AIR/2))^2)^(1/12)-1;

MathUtilities.pow(MathUtilities.pow( (1+(AIR/2)), 2), 1/12) - 1;

(3) Excel Formula: =(P*PIFM)/(1-(1+PIFM)^(-AMMO))..

(P*PIFM)/MathUtilities.pow(1-(1+PIFM), -AMMO);

(4) Excel Formula: =ROUND(PPM,2);

(float)MathUtilities.pow(PPM * 100) / 100;

[Alex McQuaid]

Thanks very much for your assistance.....Will implement the changes and let you know how the application works out.