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