You can do it like this:

=MAX(0,(60 - x) * y / 100)

so if the second term evaluates to less than 0 then 0 will be returned.

Hope this helps.

Pete


"Corcovadocowboy" wrote in
message ...
Dear Excel Community,

I have following formula:
=(60 - x) * y / 100

Sometimes x is higher than 60 and the result is a negative value.

In case of a negative value, I would like to have the value 0 in the cell.

How do I accomplish this?

Thanks for your help!

gábor