| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
| help with formula - newbie | New Users to Excel | |||
| I'm a Newbie, Need Formula | Excel Discussion (Misc queries) | |||
| Formula Problem for Newbie - Please! | New Users to Excel | |||
| Newbie needs help with formula | Excel Programming | |||
Linear Mode
