please help

%3CLINGO-SUB%20id%3D%22lingo-sub-2559820%22%20slang%3D%22en-US%22%3Eplease%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559820%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20how%20do%20i%20insert%20a%20formula%20or%20funtion%20that%20calclates%20the%20difference%20between%202%20cells%20(2%20numbers)%20when%20the%20second%20cell%20is%20the%20largest%20of%20the%202%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2559820%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-2559837%22%20slang%3D%22en-US%22%3ERe%3A%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1106370%22%20target%3D%22_blank%22%3E%40leftschool2soon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20two%20cells%20are%20A2%20and%20B2.%3C%2FP%3E%0A%3CP%3EIn%20another%20cell%2C%20for%20example%20C2%2C%20enter%20the%20formula%20%3DB2-A2%20and%20press%20Tab%20or%20Enter.%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20know%20which%20of%20the%20two%20has%20the%20largest%20value%2C%20you%20can%20use%20%3DABS(B2-A2)%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

hi how do i insert a formula or funtion that calclates the difference between 2 cells (2 numbers) when the second cell is the largest of the 2 please

1 Reply

@leftschool2soon 

Let's say the two cells are A2 and B2.

In another cell, for example C2, enter the formula =B2-A2 and press Tab or Enter.

If you don't know which of the two has the largest value, you can use =ABS(B2-A2) instead.