Thanks so much for your help. I think I am missing a step. i want each day to
calculate at .004 until the mtd is $33,000,000 then once the mtd reaches that
point the daily collections rate is .0028

Bryan Hessey wrote:
so you want to say:

=If(C$284<33000000,C$260*.004,(33000000*.004)+(C$ 260-33000000)*.0028)

ie, the first 33m at .004, the rest at .0028 ?

--

SSPAIN Wrote:
Yes i am posting daily payments. The rate before we reach mtd total of
33M
[quoted text clipped - 22 lines]
Client Support Manager
IRMC


--
Sharla Spain
Client Support Manager
IRMC

Message posted via http://www.officekb.com