so you want to say:
=If(C$284<33000000,C$260*.004,(33000000*.004)+(C$2 60-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
is the total collected for the day x.004, once the MTD( month to date)
total
reaches 33M the daily rate changes to .0028. I need the MTD to reflect
the
total of both rates once the rate changes.
Alan wrote:
Can you give a little more detail? what do you mean by 'but for some
reason
it changes the values of the preceeding cells'?
Alan.
Thanks I have tried that one but for some reason it changes the
values of
the
d text clipped - 5 lines Wrote:
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028
Please
help!
--
Sharla Spain
Client Support Manager
IRMC
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=536997