Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

PuckK1425's avatar
PuckK1425
Copper Contributor
Aug 26, 2024

Excel shows whole formula instead of outcome

Hi there,

 

I've had this issue for some time now and I cannot find the reason why. 

When I insert the IF( function, it shows me the whole formula instead of the outcome. It doesn't tell me I have made an error within the formula. In addition, I can see what the outcome should be, which is correctly shown on the right within Excel. Please see my screenshots. 

And no, I don't have the option 'Show formulas' turned on. 

Hope somebody can help me out 🙂 

 

 

 

  • PuckK1425 

    1) Make sure that the cells with the formulas are not formatted as Text.

    2) Make sure that 'Show Formulas' in the 'Formula Auditing' group of the Formulas tab of the ribbon is not highlighted.

Resources