I am using SYD to calculate hire purchase interest using "Sum of Digit"
method. That function have no problem in calculating monthly interest, the
problem I am facing is the principal amount owing within 12 months (calculate
in one cell).
Please advise!!