double quotes syntax required
I need for this :
="Yes" to appear in a cell. That cell is used in turn as part of a DCOUNT forumla to describe a set of criteria my problem is if I enter ="Yes" in that cell what actually appears is simply Yes The only other way I can think is to abuse CONCATENATE e.g. =CONCATENATE("="Yes"") but there are too many quotes. I'm guessing there's a syntax issue to resolve, but can't figure it out? |
double quotes syntax required
Brotherharry, try this
A1= '="Yes" or Range("A1").Formula = '="Yes" enjoy, Rick wrote in message oups.com... I need for this : ="Yes" to appear in a cell. That cell is used in turn as part of a DCOUNT forumla to describe a set of criteria my problem is if I enter ="Yes" in that cell what actually appears is simply Yes The only other way I can think is to abuse CONCATENATE e.g. =CONCATENATE("="Yes"") but there are too many quotes. I'm guessing there's a syntax issue to resolve, but can't figure it out? |
double quotes syntax required
Thanks. discovered I can use multiple quotes
e.g. =CONCATENATE("=","""Yes""") |
double quotes syntax required
If you just want =Yes you have to change your formula a bit:
=CONCATENATE("=";"Yes") You could also use: ="="&"Yes" If you want ="Yes" the formula should be =CONCATENATE("=";"'";"'";"Yes";"'";"'") wrote in message oups.com... I need for this : ="Yes" to appear in a cell. That cell is used in turn as part of a DCOUNT forumla to describe a set of criteria my problem is if I enter ="Yes" in that cell what actually appears is simply Yes The only other way I can think is to abuse CONCATENATE e.g. =CONCATENATE("="Yes"") but there are too many quotes. I'm guessing there's a syntax issue to resolve, but can't figure it out? |
All times are GMT +1. The time now is 05:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com