Forum Discussion

Goethestudent's avatar
Goethestudent
Copper Contributor
Sep 24, 2023
Solved

Formula components missing when I type in formula

Hello,    I just started using a MacBook for Excel. From my previous work with a Microsoft computer, I know that if you start typing in a formula, you get the components of it shown. This does not ...
Excel on Mac
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 25, 2023

    Goethestudent Ooops, Misread your question. To show the function arguments, make sure the Function Screen Tips are enabled in the Preferences..., View settings. That should fix it.

     

jerry542020's avatar
jerry542020
Copper Contributor
Sep 25, 2023

https://techstalking.co.uk/monoprice-110010-headphones-review/@ 

When you are typing a formula and components are missing or not functioning as expected, it could be due to several reasons. Here are some common issues and solutions:

  1. Typographical Errors: Double-check your formula for typos, misspellings, or incorrect syntax. Even a small mistake can cause the formula to not work.

  2. Mismatched Parentheses: Ensure that you have matching parentheses in your formula. If you open a parenthesis, you must close it. Mismatched parentheses can cause errors.

  3. Function Names: Verify that you are using the correct function names. Different software and tools may have variations in function names. Check the documentation for your specific software to confirm.

Resources