<div>
<div class="content wysiwyg-content">
is it possible to use an If statement for this<br />
<br />
if the first two numbers in string located in cell A1 are 10, then return &quot;CBM&quot;, or if first two numbers are 11, return &quot;RBWM&quot;? <br />
<br />
A1 might be 1054157521, or 11548977522 <br />
<br />
Thanks
</div>
</div>


is it possible to use an If statement for this

if the first two numbers in string located in cell A1 are 10, then return "CBM", or if first two numbers are 11, return "RBWM"? 

A1 might be 1054157521, or 11548977522 

Thanks

wild cards in IF statement

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.