I think the formula you want is -
=IF(C2=49.99,39.99*0.06,IF((C2-10)*0.06<0,0,C2-10)*0.06)

Regards.

Bill Ridgeway
Computer Solutions

"BrianC500" wrote in message
...
Hi Bill,

Thanks for the reply. I would like the fomula to return a figure of zero.

Regards

Brian

"Bill Ridgeway" wrote:

Firstly there is an error in the formula -
IF(C2=49.99,39.99*0.06,IF(C2<49.99(C2-10)*0.06))
IF(C2=49.99,39.99*0.06,IF(C2<49.99,(C2-10)*0.06))

Now, to answer the question. You can't stop the formula returning a
negative number because it is a mathematical function. You can, however,
change what it does when it gets a negative number. What do you want to
happen when the formula returns a negative number?

Regards.

Bill Ridgeway
Computer Solutions

"BrianC500" wrote in message
...
Hi,

I'm using the calculation
IF(C2=49.99,39.99*0.06,IF(C2<49.99(C2-10)*0.06))

How can I stop achieving a negative result when I put a figure of less
than
10 in C2?

Any help very much appreciated

Brian