Thank you all,

your suggestions worked fine.

gábor

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"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