| 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 |
| 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 | |||
Threaded Mode
