Simple formulas from Excel 2013 do not work in Office 365 excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2160777%22%20slang%3D%22en-US%22%3ESimple%20formulas%20from%20Excel%202013%20do%20not%20work%20in%20Office%20365%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160777%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20bough%20the%20O365%20personal%20edition%20and%20opened%20my%20Excel%20document%2C%20originally%20created%20in%20Excel%202013%20and%20to%20my%20surprise%2C%20even%20adding%20a%20new%20cell%20and%20changing%20the%20formula%20on%20the%20%22sum%22%20cell%2C%20it%20did%20not%20take%20and%20calculate%20that%20value!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20read%20all%20the%20other%20forums%20about%20making%20sure%20that%20formula%20is%20automatic%20(it%20is)%2C%20and%20type%20is%20not%20text%20(it%20isn't%20-%20it%20is%20custom)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%2C%20the%20original%20formula%20is%3A%26nbsp%3B%3CEM%3E%3D(J1234%2BK1234-B1234)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20a%20new%20value%20in%20the%20colum%20%22L%22..%20now%20it%20is%3A%26nbsp%3B%26nbsp%3B%3CEM%3E%3D(J1234%2BK1234%3CSTRONG%3E%2BL1234%3C%2FSTRONG%3E-B1234)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23FF0000%22%3EIt%20did%20not%20add%20the%20value%20contained%20in%20L1234%3C%2FFONT%3E%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EAm%20I%20doing%20something%20wrong%3F%20It%20is%20a%20brand%20new%20installed%20and%20newly%20opened%20so%20I%20don't%20need%20to%20%22repair%22%20office%20365%20as%20it%20was%20the%20first%20time%20using%20it%20and%20already%20it%20is%20wrong.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EThoughts%3F%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EThanks%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2160777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2161273%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20formulas%20from%20Excel%202013%20do%20not%20work%20in%20Office%20365%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2161273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F976648%22%20target%3D%22_blank%22%3E%40lngCDN%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20whether%20the%20%22custom%22%20type%20has%20anything%20to%20do%20with%20it.%20Why%20not%20%22number%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20is%20it%20possible%20for%20you%20to%20attach%20the%20spreadsheet%20with%20that%20errant%20total%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

So I bough the O365 personal edition and opened my Excel document, originally created in Excel 2013 and to my surprise, even adding a new cell and changing the formula on the "sum" cell, it did not take and calculate that value! 

 

I read all the other forums about making sure that formula is automatic (it is), and type is not text (it isn't - it is custom)

 

for example, the original formula is: =(J1234+K1234-B1234)

 

I added a new value in the colum "L".. now it is:  =(J1234+K1234+L1234-B1234)

 

It did not add the value contained in L1234  

 

Am I doing something wrong? It is a brand new installed and newly opened so I don't need to "repair" office 365 as it was the first time using it and already it is wrong.

 

Thoughts?

 

Thanks

 

 

 

 

1 Reply

@lngCDN 

 

I'm wondering whether the "custom" type has anything to do with it. Why not "number"?

 

Anyway, is it possible for you to attach the spreadsheet with that errant total?