Is there any way I can use an IF statement to see if a cell begins with a 2 (or a 3 or 4)?
Thanks
Is there any way I can use an IF statement to see if a cell begins with a 2 (or a 3 or 4)?
Thanks
=IF(LEFT(A2,1)="2","yes","no")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
=IF(AND(--LEFT(A1,1)>1,(--LEFT(A1,1)<5)),TRUE,FALSE)
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
= IF(AND(49<CODE(A1),CODE(A1)<53),"yes","no")
With the below formula you will be able to check any number if exist...
=ISNUMBER(VALUE(LEFT(A1,1)))
...
Thanks for all your replies.
Posting Permissions
Reply With Quote
