count result as zero unless positive value

is there a way to get a formula to count a zero if it would normally return a negative value?

example

result = 100
target =300
result = -200

but i want it to show as zero

does this make sense?

i'll bet its really simple but i'm stuck

any help appreciated

Hello jimb0693,

A function can not be changed to return zero for a number less than zero unless it has been programmed that way. You can use an IF statement to test the results and return a zero for result s that are negative.

Please Login or Register  to view this content.

Another alternative would be to use MAX:

=MAX(0,result-target)

so the output is the greater of 0 and the calculation result.

I have read that MAX executes about 40% faster than an IF