Formula sign

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel course london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Urgent Priority · Version 2007

Formula sign

Icaro has attended:
Excel Intermediate course

by - delegate Icaro [2 posts] (2008 May 20 Tue, 12:24) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Formula sign

by - trainer Thia [6 posts] (2008 May 20 Tue, 21:35) Reply

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

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Excel in the Home Office
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Office and the Small Business: Part 1 Excel
· Microsoft Excel Training: Essential for Today's Employees

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Rate this page: