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
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
