Forum Discussion
Naz17
Jun 29, 2021Copper Contributor
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 ...
Riny_van_Eekelen
Jun 29, 2021Platinum Contributor
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.