SOLVED
Quotation marks in a formula
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
miki2024
6 - Meteoroid
04-07-2023
06:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Any chance the difference between "" and '' when creating an IF formula?
IF [sales report]="sales20230404" THEN "April sales" ELSE "Others" ENDIF
I wonder if I have to use double quotation for CONTAINS formula and IF formula?
thanks a bunch!
Solved! Go to Solution.
Labels:
- Labels:
- Expression
1 REPLY 1
17 - Castor
04-07-2023
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @miki2024, you can use either! The only time you’ll need to be particular is if you have one type of quotation marks in the string itself. I.e. you’d need to use double quotes if there are single quotes in the target and vice versa.
For example: “He said ‘Hello’ to me” has to be wrapped with double quotes because there’s single quotes inside. Inversely, ‘He said “Hello” to me’ is wrapped in singles as there’s double within.
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)