Home

Formula incomplete error won't close

%3CLINGO-SUB%20id%3D%22lingo-sub-803234%22%20slang%3D%22en-US%22%3EFormula%20incomplete%20error%20won't%20close%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803234%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20accidentally%20typed%20a%20%22-%22%20sign%20into%20an%20empty%20cell%2C%20and%20excel%20is%20returning%20the%20error%20message%20%22Your%20formula%20is%20incomplete.%22%20The%20only%20option%20for%20this%20warning%20is%20to%20press%20the%20%22OK%22%20button%3B%20however%2C%20when%20I%20do%20this%2C%20it%20immediately%20brings%20the%20message%20back%20up%20again.%20I%20can't%20access%20any%20of%20my%20other%20spreadsheets%2C%20and%20the%20application%20itself%20won't%20quit%2C%20either.%20Any%20idea%20on%20how%20I%20can%20get%20rid%20of%20this%20message%20if%20the%20button%20to%20close%20it%20isn't%20doing%20anything%3F%20Such%20a%20small%20thing%20is%20causing%20all%20of%20Excel%20to%20have%20a%20fit!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-803234%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803378%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20incomplete%20error%20won't%20close%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803378%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391777%22%20target%3D%22_blank%22%3E%40Taylor_Machette%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20hitting%20the%26nbsp%3B%3CSTRONG%3EEsc%3C%2FSTRONG%3Ekey%20instead%20of%20selecting%20%22Ok%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Taylor_Machette
New Contributor

Hello,

 

I accidentally typed a "-" sign into an empty cell, and excel is returning the error message "Your formula is incomplete." The only option for this warning is to press the "OK" button; however, when I do this, it immediately brings the message back up again. I can't access any of my other spreadsheets, and the application itself won't quit, either. Any idea on how I can get rid of this message if the button to close it isn't doing anything? Such a small thing is causing all of Excel to have a fit!

 

Thank you

3 Replies

Hello @Taylor_Machette,

 

Have you tried hitting the Esc key instead of selecting "Ok"?

Hi @PReagan ,

 

Yes, I have. That doesn't do anything but make a loud error noise on my Mac, unfortunately.

@Taylor_Machette,

 

Unfortunately, I have a PC so I cannot replicate your issue. However, I came across this possible solution:

 

https://answers.microsoft.com/en-us/msoffice/forum/all/stuck-in-error-message-loop/ccdb1ab5-1b44-4c0...

 

Hope this helps!

PReagan

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies