View Full Version : Solved: Check if cell begins with number
realitybend
07-22-2008, 04:08 PM
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
Bob Phillips
07-22-2008, 04:10 PM
=IF(LEFT(A2,1)="2","yes","no")
mdmackillop
07-22-2008, 04:13 PM
=IF(AND(--LEFT(A1,1)>1,(--LEFT(A1,1)<5)),TRUE,FALSE)
mikerickson
07-22-2008, 08:52 PM
= IF(AND(49<CODE(A1),CODE(A1)<53),"yes","no")
ilyaskazi
07-22-2008, 09:59 PM
With the below formula you will be able to check any number if exist...
=ISNUMBER(VALUE(LEFT(A1,1)))
...
realitybend
07-23-2008, 11:17 AM
Thanks for all your replies.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.