Excel won't let me enter formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2649184%22%20slang%3D%22en-US%22%3EExcel%20won't%20let%20me%20enter%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649184%22%20slang%3D%22en-US%22%3EI%20have%20tried%20literally%20everything%20to%20fix%20this%20formula%20and%20It%20still%20hasn't%20worked.%20This%20is%20the%20exact%20formula%20my%20professor%20gave%20me%20and%20she%20even%20said%20she%20doesn't%20know%20why%20excel%20won't%20allow%20it%20because%20I%20typed%20it%20correctly.%20Can%20anyone%20please%20help%3F%3F%20Im%20stressed%20out%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2649184%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2649227%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20won't%20let%20me%20enter%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128675%22%20target%3D%22_blank%22%3E%40dianakay%3C%2FA%3E%26nbsp%3BThe%20formula%20in%20the%20photo%20seem%20to%20use%20structured%20table%20references%2C%20but%20are%20you%20indeed%20working%20with%20such%20structured%20tables%20where%20the%20column%20headers%20are%20exactly%20as%20used%20in%20the%20formula%3F%20That%20is%2C%20%22Operating_Income%22%20and%20%22Net_Sales%22%2C%20both%20with%20the%20underscore.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20can%20upload%20the%20workbook%20instead!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2649244%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20won't%20let%20me%20enter%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649244%22%20slang%3D%22en-US%22%3EHi!%20Thank%20you%20for%20responding!%20I%20have%20a%20picture%20of%20the%20directions%20that%20were%20included%20in%20the%20excel%20sheet%20on%20how%20to%20type%20the%20formula%20in.%20I%20just%20typed%20exactly%20what%20I%20was%20told%20and%20it%20wasn%E2%80%99t%20working%2C%20I%20even%20tried%20removing%20the%20%40%20sign%20but%20nothing%20seemed%20to%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2649261%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20won't%20let%20me%20enter%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128675%22%20target%3D%22_blank%22%3E%40dianakay%3C%2FA%3E%26nbsp%3BI'm%20not%20doubting%20that%20you%20exactly%20did%20as%20instructed%2C%20but%20the%20message%20you%20showed%20in%20your%20first%20post%20indicated%20that%20something%20was%20entered%20in%20a%20way%20that%20Excel%20doesn't%20like%20or%20recognize.%3C%2FP%3E%3CP%3EUpload%20your%20workbook%20instead%20of%20huge%20PDFs%2C%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I have tried literally everything to fix this formula and It still hasn't worked. This is the exact formula my professor gave me and she even said she doesn't know why excel won't allow it because I typed it correctly. Can anyone please help?? Im stressed out
4 Replies

@dianakay The formula in the photo seem to use structured table references, but are you indeed working with such structured tables where the column headers are exactly as used in the formula? That is, "Operating_Income" and "Net_Sales", both with the underscore.

 

Perhaps you can upload the workbook instead!

Hi! Thank you for responding! I have a picture of the directions that were included in the excel sheet on how to type the formula in. I just typed exactly what I was told and it wasn’t working, I even tried removing the @ sign but nothing seemed to work.

@dianakay I'm not doubting that you exactly did as instructed, but the message you showed in your first post indicated that something was entered in a way that Excel doesn't like or recognize.

Upload your workbook instead of huge PDFs, please.

@dianakay Just noticed now that the instruction does not include the underscore in the column names where the formula you tried to enter does have underscores. Furthermore, the green table in the instructions is indeed a structured tables where as the one you seem to be working on is not.