Calculate difference between 2 numbers, up to a certain number

[RJB78]

Hello. Looking to calculate the difference between 2 numbers, up a certain max amount. Example: I want to find the difference between 200 (A1) and 100 (A2), which is 100 but allow the formula to give me the difference up to 80, meaning return '80'. But if the number in A1 was 150, and A2 was 100, it would return 50.

Thank you in advance

 

[offthelip]

=MIN(A1-A2,80)

 

[RJB78]

=MIN(A1-A2,80)

That worked perfectly. Thank you. What about a minimum return of '0' 75 (A1) - 100 (A2) = 0

 

[Peter_SSs]

Try

=MEDIAN(0,80,A1-A2)

or

=MAX(MIN(A1-A2,80),0)