Forum Discussion

Taylor_Machette's avatar
Taylor_Machette
Copper Contributor
Aug 13, 2019

Formula incomplete error won't close

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; how...
excel
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Aug 13, 2019

Hello Taylor_Machette,

 

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

  • SimonneDB7's avatar
    SimonneDB7
    Copper Contributor
    Dec 22, 2023
    Thank you, you have saved my life!
  • Taylor_Machette's avatar
    Taylor_Machette
    Copper Contributor
    Aug 13, 2019

    Hi PReagan ,

     

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

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Aug 13, 2019

      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-4c0c-a3e0-c399cca78f91

       

      Hope this helps!

      PReagan

Resources