98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula sign
Formula sign
Resolved · Urgent Priority · Version 2007
Tue 20 May 2008, 12:24Delegate Icaro said...
Icaro has attended:
Excel Intermediate course
Formula sign
Hi,
I am trying to write a formula, so that 'if the text in cell A2,b2,c2,etc are in the range of values (or 'belong to' one fo teh values in the range) in cells L2 to L30, then the formula where i'm typing the formula should say yes, otherwise no;
I've written =if(a2=$l$1:$l$30),"yes","no") but is not working;
Any ideas? i thought maybe using the symbol for 'belong to' could be the solution, but don't know ithe excel symbol for this.
Thanks
Tue 20 May 2008, 21:35Trainer Thia said...
RE: Formula sign
Hello Icaro
Thanks for your question. If you have typed in the statement exactly as you have written it in your question then it could simply be a problem with brackets.
Your if statement should have an open left bracket after the if and then a closing round bracket at the end.
Try removing the closing round bracket after 30.
I hope this solves the problem. If it doesn't, please let us know.
Regards
Thia
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
