Help!! Using IF statements for the 1st Time
 

Im trying to clean up data in my worksheet in Column B there is Locatio
Numbers that start with eg UG, UG-100 etc my following IF statement onl
gives me a Yes for the Rows with UG only but I want the UG-100 to com
up with a Yes to and a No for any other data which shouldn't be in tha
colum

=IF(B2="UG","yes","No"

--
gingerbrea
-----------------------------------------------------------------------
gingerbread's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56941

Help!! Using IF statements for the 1st Time
 

=IF(LEFT(B2,2)="UG","yes","No")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gingerbread" wrote in message
...
|
| Im trying to clean up data in my worksheet in Column B there is Location
| Numbers that start with eg UG, UG-100 etc my following IF statement only
| gives me a Yes for the Rows with UG only but I want the UG-100 to come
| up with a Yes to and a No for any other data which shouldn't be in that
| column
|
|
| =IF(B2="UG","yes","No")
|
|
| --
| gingerbread
| ------------------------------------------------------------------------
| gingerbread's Profile: http://www.excelforum.com/member.php...o&userid=37233
| View this thread: http://www.excelforum.com/showthread...hreadid=569414
|

Help!! Using IF statements for the 1st Time
 

Thanks mate much appreciate

--
gingerbrea
-----------------------------------------------------------------------
gingerbread's Profile: http://www.excelforum.com/member.php...fo&userid=3723
View this thread: http://www.excelforum.com/showthread.php?threadid=56941