Hi. Perhaps another option...

= Max(0, Min(30000, 0.015*(J10 - 3000000)]))

= = =
HTH
Dana DeLouis


kim wrote:
Thanks. here is my original formula:

=IF((J10-3000000)=2000001,30000,0.015*(J10-3000000))


"Mike Fogleman" wrote:

=IF(A1-B1<0,0,A1-B1)
If you had supplied your formula, I could have given the full answer. This
would become part of your original formula.

Mike F
"kim" wrote in message
...
I have an IF function and I want to add that if the end result ends up
beign
a negative number, it should be set it to zero rather than the negative
number. But I don't know how to do that in conjunction with an already
complete If statement. Any help is much appreciated. Thank you