Ensuring a cell doesn't show a negative number

[ForeverUnited]

Hi,

I have the following code in N2

=(E2*0.1)-35

And it is showing a negative number which is correct. The issue is, I want it to show 0 if the number is negative, how can I achieve this please?

Thanks again.

 

[James006]

Hi,

You could test following

=IF(E2<350,0,(E2*0.1)-35)

Hope this will help

 

[ForeverUnited]

Hi,

You could test following

=IF(E2<350,0,(E2*0.1)-35)

Hope this will help

Hi James,

Thanks, that's done it!

 

[James006]

You are welcome

 

[Fluff]

FWIW, you could also use
=MAX((E2*0.1)-35,0)

 

[ForeverUnited]

Hi,

I now have this one:

=P2*0.2

In R2, bu again would like to ensure that doesn't show a negative number (show 0 if it would have been negative).

I have tried working it out myself using the se formulas but just can't get it, can someone please help?

Thanks.

 

[RoryA]

=MAX(0,P2*0.2)

should suffice.

 

[ForeverUnited]

=MAX(0,P2*0.2)

should suffice.

Perfect, thanks a lot.