The second IF function (nested) isn't necessary since if C2 failed to meet
the first criterion where C2=49.99 then it is mandated to be less than
49.99. Also, since 39.99*0.06 is a hard number, the second of the two formula
options below lists this number (2.399) instead:

=If(C2=49.99, 39.99*0.06, Max(C2-10, 0)*0.06)
=IF(C2=49.99,2.399,MAX(C2-10,0)*0.06)

Regards,
Greg

"BrianC500" wrote:

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