Thread
:
Formula help for a newbie, please
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Formula help for a newbie, please
try
=IF(OR(AND(LEFT(A12,1)="w",LEFT(B12,1)="w"),AND(LE FT(A12,1)="x",LEFT(B12,1)="x")),100,9999)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"SedonaBob" wrote in message
...
Columns A and B each can have two-character text beginning with either the
letter "W" or the letter "X". If the text in both columns begin with the
same letter, Column C would be 100, but if the text in the columns begin
with
different letters, Column C would be 999.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett