Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a function returns zero if the number of negative.
EX: -25 = 0
30=30
-35=0
Thank you
=If(Field > 0,Field,0)
Hello Thanks for the reply , but do not want to use one if I would like a function to do that
(fabs(Field)+Field)/2
rangemax(0, Field)
Maybe you could use the fabs function:
=(fabs(X)+X)/2
This way you get 0/2 if negative and 2X/2=X if positive.