Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time and if statements | Excel Worksheet Functions | |||
If Statements With Time of Day | Excel Discussion (Misc queries) | |||
IF Statements and Time | Excel Worksheet Functions | |||
Using "IF" and "AND" statements with current time | Excel Worksheet Functions | |||
Working with If statements and time | Excel Worksheet Functions |