| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Wildcard in an IF Statement
I have a column of data, some of which I want to mathematically operate on
and some of which I do not. The cells which I do wish to use to flag the need to operate will all contain text that starts with the letter "U". Is there a way to say in an IF Statement "IF cell B3 contains text that begins with a "U", then run my desired calculation on 2 other cells? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Wildcard in an IF Statement
=IF(LEFT(B2,1)="U","do something","do something else")
-- Gary''s Student - gsnu200775 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard character in an "If" statement? | Excel Worksheet Functions | |||
| Wildcard for Conditional Sum Wizard statement. | Excel Worksheet Functions | |||
| If statement to compare for wildcard value in another cell. | Excel Worksheet Functions | |||
| How do I use a wildcard in an if statement? | Excel Discussion (Misc queries) | |||
| Wildcard Not Working in IF statement | Excel Worksheet Functions | |||
Linear Mode
