Adding equals sign in a cell gives error in the formula result bar at bottom.

Whenever I try inserting a formula by pressing equals sign, the bottom formula result bar says 'the formula should not begin with equals sign'. It gives same error message irrespective of cell format (auto, numbers, currency etc). Please check screenshot. Just to inform, it calculates and gives correct results in both conditions when formula started with equals sign and when without equals sign. Why's it giving that message???



[Edited by Moderator]

MacBook Air 15″, macOS 26.0

Posted on Oct 6, 2025 10:39 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 6, 2025 11:25 AM

You don't need a second equals sign.


When you select a cell and press =, Numbers infers that you want this cell to be a formula and displays the formula entry box. You don't need another = inside this box... the initial one is sufficient to tell Numbers that you're entering a formula.


The message itself is just a warning. Numbers will delete the = sign after you enter the formula, which is why the formula continues to work, even with the warning.

1 reply
Question marked as Top-ranking reply

Oct 6, 2025 11:25 AM in response to Formula-result-bar-error

You don't need a second equals sign.


When you select a cell and press =, Numbers infers that you want this cell to be a formula and displays the formula entry box. You don't need another = inside this box... the initial one is sufficient to tell Numbers that you're entering a formula.


The message itself is just a warning. Numbers will delete the = sign after you enter the formula, which is why the formula continues to work, even with the warning.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Adding equals sign in a cell gives error in the formula result bar at bottom.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.