ExcelBanter - Using Wildcard in an IF Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using Wildcard in an IF Statement (https://www.excelbanter.com/excel-discussion-misc-queries/181375-using-wildcard-if-statement.html)

ConfusedNHouston

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,

Gary''s Student

Using Wildcard in an IF Statement

=IF(LEFT(B2,1)="U","do something","do something else")
--
Gary''s Student - gsnu200775

All times are GMT +1. The time now is 09:03 AM.