Formula help for a newbie, please
 

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.

Formula help for a newbie, please
 

Put this in cell C1 and copy it down:
=IF(LEFT(A1,1)=LEFT(B1,1),100,999)

HTH,
Matthew Pfluger

"SedonaBob" wrote:

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.

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.

Formula help for a newbie, please
 

Better if col a and col b can NOT have anything but w or x

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Matthew Pfluger" wrote in
message ...
Put this in cell C1 and copy it down:
=IF(LEFT(A1,1)=LEFT(B1,1),100,999)

HTH,
Matthew Pfluger

"SedonaBob" wrote:

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.

Formula help for a newbie, please
 

Thank you!

"Don Guillett" wrote:

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.

Formula help for a newbie, please
 

Thank you!

"Matthew Pfluger" wrote:

Put this in cell C1 and copy it down:
=IF(LEFT(A1,1)=LEFT(B1,1),100,999)

HTH,
Matthew Pfluger

"SedonaBob" wrote:

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.