Display a zero if formula results in a negative number

[Qazxswe]

I have a formula that displays calculates a number:

=(D34-((D34/36)*F34))*C34

I'm trying to come up with a way which means that if the value is a negative number it changes it to zero (or perhaps errors)

If I use custom data validation on the result cell, I can't enter a negative number, but if the formala calculation results in a negative, the DV seems to be ignored. I've also tried a =MAX function with no success. What is the best way to achieve this? To confirm; I want the number to be a zero, not just display as zero, so if I was to sum the results it is not included in the calculation at all.

Any suggestions

 

[bebo021999]

You said you have tried MAX already. what was it?

Anyway, try:

=MAX(0,(D34-((D34/36)*F34))*C34)

Does it work?

 

[Qazxswe]

That works a treat! Must have got the syntax wrong - many thanks!

 

[Peter_SSs]

A minor thing, but you have a couple of sets of parentheses that don't actually do anything. This should do the same thing.

=MAX(0,(D34-D34/36*F34)*C34)