Help!! Using IF statements for the 1st Time

[gingerbread]

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

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gingerbread" <[email protected]> wrote in message
news:[email protected]...
|
| 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
|

[gingerbread]

Thanks mate much appreciated