i am attempting to write a formula that says
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028 Please help!

=If(C$284<33000000,C$260*.004,If(C$28433000000,C$ 260*.0028,""))

but you probably didn't want to leave =33000000 - so

=If(C$284<33000000,C$260*.004,C$260*.0028,"")
or
=If(C$284<=33000000,C$260*.004,C2$60*.0028,"")

Hope this helps

--

SSPAIN Wrote:
i am attempting to write a formula that says
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028
Please help!


--
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

=IF(C$28433000000,C260*0.004,C260*0.0028)
Alan.
"SSPAIN" <u21294@uwe wrote in message news:5f6b0af31a910@uwe...
i am attempting to write a formula that says
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028 Please
help!

Thanks I have tried that one but for some reason it changes the values of the
preceeding cells. This is a rate change formula I need to show daily
according to the amount collected. I am at a lost .
Alan wrote:
=IF(C$28433000000,C260*0.004,C260*0.0028)
Alan.
i am attempting to write a formula that says
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028 Please
help!

--
Sharla Spain
Client Support Manager
IRMC

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.

"SSPAIN" <u21294@uwe wrote in message news:5f6b611de182b@uwe...
Thanks I have tried that one but for some reason it changes the values of
the
preceeding cells. This is a rate change formula I need to show daily
according to the amount collected. I am at a lost .
Alan wrote:
=IF(C$28433000000,C260*0.004,C260*0.0028)
Alan.
i am attempting to write a formula that says
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028 Please
help!

--
Sharla Spain
Client Support Manager
IRMC

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
[quoted text clipped - 5 lines]
if c$284<33000000 then c260*.004 or if c33000000 then c260*.0028 Please
help!

--
Sharla Spain
Client Support Manager
IRMC

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

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

I presume that your daily entries are on consecutive rows, if so then
formula drag the calculation down each row, but you will need to use a
point other than C$284 for your test and other than C$260 for the
amount to be used, othewise when C284 passes 33m then all rows will
change calculation.
What formula is in C284 and C260 ?

Perhaps something like:


=if(C2="","",If(SubTotal(9,C$2:C2)<=33000000,SubTo tal(9,C$2:C2)*.004,(33000000*.004)+(SubTotal(9,C$2 :C2)-33000000)*.0028))

would be more appropriate.


If you are amending the same cell each day then you will need some VB
Code to detect your change and accumulate the total to date.

Hope this helps

--

SSPAIN via OfficeKB.com Wrote:
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
d text clipped - 22 lines Wrote:

Client Support Manager
IRMC


--
Sharla Spain
Client Support Manager
IRMC

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


--
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