Re: formula

Giganews Newsgroups
Subject: Re: formula
Posted by:  Sandy Mann (sandyman…@mailinator.com)
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)

--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandyman…@mailinator.com
Repla…@mailinator.com with @tiscali.co.uk

"Amy" <A…@discussions.microsoft.com> wrote in message
news:5B347615-C2A4-454C-8D76-4AF985F63D…@microsoft.com...
>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

Replies

None

In response to

formula posted by amy on Tue, 23 May 2006