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