Forum Discussion
A B
Jun 01, 2018Copper Contributor
Ctrl F brings up debug window instead of find
Sometimes when I have the same excel file open for hours, when I press ctrl f it brings up the debug function instead of the find menu. When I close excel and reopen the file, the normal ctrl f funct...
- Jun 02, 2018
Are any of the files you are opening .xlsm files?
Do you have any addins installed?
Also try pressing Alt + F11 to see if the PERSONAL.XLSB workbook has any modules in it
Wyn Hopkins
Jun 02, 2018MVP
Are any of the files you are opening .xlsm files?
Do you have any addins installed?
Also try pressing Alt + F11 to see if the PERSONAL.XLSB workbook has any modules in it
A B
Jun 05, 2018Copper Contributor
Aha! Yes, one of my documents that I often have open had modules added--it was a template I got from someone else. I removed the modules and the problem was fixed. Thank you!
- SergeiBaklanDec 14, 2021MVP
The difference between negation and subtraction relating to Excel is discussing for at least 25 years. Logical negation has function as NOT(). For arithmetic negation it is used "minus" sign in front of expression. Virtually you may consider it something like =NAR(expression) which has high priority instead of =-expression.
For the sample
=-(A2+1)^2 => NAR(A2+1) ^ 2 == (-(A2+1))^2
That's not Excel specific, same is in Google Sheets and any programming language which use minus as arithmetic negation.
- JAGGyulaDec 17, 2021Copper ContributorThank you for the answer. Ok, now I understand, why it is happened. If it is would be in the visual basic, I even can accept, but in the excel I can't, because the mathematics rules are definite and this is not a program language. For example, I won't accept this answer from a student, if he made a same error in a calculation.
- SergeiBaklanDec 18, 2021MVP
If consider Excel as calculator with lot of unnecessary features - yes, it shall be school math. If consider Excel as data modelling tool, which is it, it has to have negation and negation works as it works everywhere.
That's not Excel specific, any spreadsheet tool. If you enter
=-5^2
each of Excel, Google Sheets or Zoho Sheet (I believe any other one) return +25. The only difference, some tools as Zoho Sheet automatically converts above formula to
=(-5)^2
which you may see in formula bar.
Again, the key is do we have negation operator or not. School math doesn't introduce it, calculators don't have it. Spreadsheets and programming languages have. As soon as you have such operator you shall accept order of operations with it and don't miss negation with subtraction, even if they have the same minus symbol to indicate the operator.
- Riny_van_EekelenDec 14, 2021Platinum Contributor
JAGGyula Similar to a problem discussed and explained by JoeUser2004 , in the link below: