Forum Discussion
Curly Brackets used to denote Text Strings
I am having an issue of needing to use Curly brackets along with double apostrophes to denote a text string within an Excel formula, or else an error is thrown.
As a simple example for the below IF function, the formula does not recognise the word "Yes" unless i encircle the Yes along with the double apostrophe in curly brackets. How do i change this setting in Excel?
2 Replies
Not sure what you are doing. See the picture below. You shouldn't need the curly brackets.
=IF(B1="Yes",A1,0)Otherwise upload your file.
Ooops: Third in line, didn't see the other answers until I submitted mine.
The curly brackets are valid as the definition of a single element constant-array, but should not be required unless you are performing multiple tests simultaneously.
What version of Excel are you using?
