symbols

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Symbols

Symbols

resolvedResolved · 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


 

Excel tip:

3D formulas find and replace

After 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.

View all Excel hints and tips


Server loaded in 0.08 secs.