Share via

Why does excel display my formula in the cell, instead of the results of the formula?

Anonymous
2024-03-20T21:49:55+00:00

I've entered this formula in cell AD7:

=IF(AB7>3,"Success","Fail")

Excel displays this formula in the cell, instead of the result. I know it's trying to tell me there is a problem, but I can't figure out what the problem might be.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-03-20T22:09:32+00:00
    • Make sure that there is no space before the = sign.
    • Make sure that the cell is not formatted as Text. If it is, set the number format to General, then press F2 and press Enter without changing anything.
    • Make sure that the Show Formulas button in the Formula Auditing group of the Formulas tab of the button is not highlighted.
    • If you use comma as decimal separator, you should use semicolons instead of commas in the formula: =IF(AB7>3;"Success";"Fail")

    100+ people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest