Do I need an IF THEN formula?

Copper Contributor

Column C shows what I want for the correct answer.

The diff between column A and B should be a max of 975.

How do I create a formula in Column C that shows that?

 

A             B         C  

5000     6000     5975

6000    6500      6500

1 Reply
Try this in C2:
=MIN(A2,B2)+
MIN(ABS(A2-B2),
975)