View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
 
Posts: 41
Default 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,