Solving for simple equations

%3CLINGO-SUB%20id%3D%22lingo-sub-1546183%22%20slang%3D%22en-US%22%3ESolving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546183%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20the%20answer%20to%20a%20simple%20equation%20to%20appear%20in%20last%20column%20of%20a%20table.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20equation%20is%20B2-D2-x%3D27%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20answer%20to%20x%20to%20appear%20in%20E2.%20%26nbsp%3BI%20know%20there%20is%20a%20way%20to%20make%20this%20happen%20but%20I%20have%20yet%20to%20find%20it.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1546183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546210%22%20slang%3D%22en-US%22%3ERe%3A%20Solving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740047%22%20target%3D%22_blank%22%3E%40mpruitt1050%3C%2FA%3E%26nbsp%3B%2C%20Will%20this%20in%20E2%20work%3F%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DB2-D2-27%20%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546577%22%20slang%3D%22en-US%22%3ERe%3A%20Solving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546577%22%20slang%3D%22en-US%22%3EEnter%20this%20formular%20if%20C3%20is%20%22X%22%3CBR%20%2F%3E%3D(B3-D3)-C3%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546584%22%20slang%3D%22en-US%22%3ERE%3A%20Solving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546584%22%20slang%3D%22en-US%22%3E%3D(B2-D2)-C2%20...if%20C2%20is%20%22x%22%20....enter%20this%20formular%20in%20E2.%20For%20the%20sake%20of%20being%20correct%20since%20you%20requested%20E2%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546877%22%20slang%3D%22en-US%22%3ERe%3A%20Solving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546877%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20did!%20%26nbsp%3BThanks!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546881%22%20slang%3D%22en-US%22%3ERe%3A%20Solving%20for%20simple%20equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740047%22%20target%3D%22_blank%22%3E%40mpruitt1050%3C%2FA%3E%26nbsp%3BHappy%20to%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want the answer to a simple equation to appear in last column of a table.  

 

The equation is B2-D2-x=27

 

I want the answer to x to appear in E2.  I know there is a way to make this happen but I have yet to find it.  

 

5 Replies

@mpruitt1050 , Will this in E2 work?

=B2-D2-27 
Enter this formular if C3 is "X"
=(B3-D3)-C3

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)
=(B2-D2)-C2 ...if C2 is "x" ....enter this formular in E2. For the sake of being correct since you requested E2

It did!  Thanks! @TheAntony 

@mpruitt1050 Happy to help!