Negative values turn into zero values

[Corcovadocowboy]

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

 

[Pete_UK]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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

 

[Joel]

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

 

[Corcovadocowboy]

Thank you all,

your suggestions worked fine.

gábor