Re: formula

Giganews Newsgroups
Subject: Re: formula
Posted by:  Sandy Mann (sandyman…
Date: Tue, 23 May 2006

With the Penalty amount in D2, Interest amount in E2, Principal amount in F2
and the Payment in C3, see if this does what you want:

D3:  =D2-MIN(D2,C3)

E3:  =E2-MIN(C3-D2,E2,C3)

F3:  =F2-MIN(C3-D2-E2,C3)


In Perth, the ancient capital of Scotland

Repla… with

"Amy" <A…> wrote in message
>I am trying to work on a spreadsheet and am stuck on how to approach a
> formula.  I have a spreadsheet that calculates three numbers called
> penalty,
> interest and principal.  I then have to have a formula that applies a
> payment
> to each item in a certain order.  Once I receive a payment it has to be
> first
> allocated to the penalty, then if any is left over it has to reduce the
> interest, then finally it gets applied to the principal.  In other words I
> am
> looking to set a formula with specific payment allocation.  I was trying
> to
> do it with an if then statement but am very stuck any ideas
> --
> Amy



In response to

formula posted by amy on Tue, 23 May 2006