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

"Corcovadocowboy" wrote:

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