Absolute value with IF statement

[beancounter]

I have a forumula as below

=IF((M20-21>0+0)*(M20-21<41+0),M20-21,(M20-21)-40)

It seems to work but if the # in M20 is less than 61 I get a negative number. I don't want the forumula to return negative numbers. How do I change the formula to make negative #'s be zero?????

Thanks,
John

 

[dave3009]

=IF(M20<61, 0, IF((M20-21>0+0)*(M20-21<41+0),M20-21,(M20-21)-40))

 

[Aladin Akyurek]

=MAX(0,IF(((M20-21) > 0)*(M20-21 < 41), M20-21, (M20-21)-40))

 

[barry houdini]

Try

=IF(M20<=21,0,M20-IF(M20>=62,61,21))

 

[beancounter]

Dave3009,

I'm trying to determine if a number M20 - 21 units is greater than 0 but less than 40.

If so I need M20 - 21, but if M20 - 21 is greater than 40, I need (M20 - 21) -40 and have that # either be positve or zero.

Hope that makes sense.

John