98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Symbols
Symbols
Resolved · High Priority · Version 2003
Tom has attended:
Excel Advanced course
Symbols
Hi
Please can somebody explain how the {} symbols work?! I have them surrounding a formula in a cell which is an invalid formula but the cell still returns a number that is always the same. If I try to edit the formula or remove the {}, the cell rightly reverts to a VALUE!# error. Where has the number come from?
Regards
Tom
RE: Symbols
Hello Tom
Thank you for your question.
Formulas that occur inside {} are array formulas. I would suggest looking up arrays in Excel Help to be able to troubleshoot what is going on with the formula. But the formula definitely won't work if you remove the {}
Kind regards
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:3D formulas find and replaceAfter you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be. |