Home

Do I need an IF THEN formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-904455%22%20slang%3D%22en-US%22%3EDo%20I%20need%20an%20IF%20THEN%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904455%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20C%20shows%20what%20I%20want%20for%20the%20correct%20answer.%3C%2FP%3E%3CP%3EThe%20diff%20between%20column%20A%20and%20B%20should%20be%20a%20max%20of%20975.%3C%2FP%3E%3CP%3EHow%20do%20I%20create%20a%20formula%20in%20Column%20C%20that%20shows%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3BC%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E5000%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%206000%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%205975%3C%2FP%3E%3CP%3E6000%26nbsp%3B%26nbsp%3B%26nbsp%3B%206500%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%206500%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-904455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-904520%22%20slang%3D%22en-US%22%3ERe%3A%20Do%20I%20need%20an%20IF%20THEN%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904520%22%20slang%3D%22en-US%22%3ETry%20this%20in%20C2%3A%3CBR%20%2F%3E%3DMIN(A2%2CB2)%2B%3CBR%20%2F%3EMIN(ABS(A2-B2)%2C%3CBR%20%2F%3E975)%3C%2FLINGO-BODY%3E
Joan McRae
New 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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies