Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
A B
1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
In B1 enter
+IF(A1="","",IF LEFT(A1,2)="av","avsp",IF(LEFT(A1,1)="a","act",IF( LEFT(A1,1)="h","hp","")))) -- HTH Kassie Replace xxx with hotmail "scootr" wrote: A B 1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
=IF(LEFT(A1,2)="av","avsp",IF(LEFT(A1)="a","act"," hp"))
-- David Biddulph "scootr" wrote in message ... A B 1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
=IF(LEFT(A1,2)="av","avsp",(IF(LEFT(A1,1)="a","act ","hp")))
-- Gary''s Student - gsnu200906 "scootr" wrote: A B 1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF MID formula
Thanks.
"David Biddulph" wrote: =IF(LEFT(A1,2)="av","avsp",IF(LEFT(A1)="a","act"," hp")) -- David Biddulph "scootr" wrote in message ... A B 1 a20 I want cell B1 to read "act" if A1 begins with an "a" or B1 reads "avsp" if A1 begins with an "av" or B1 reads "hp" if A1 begins with an "h" (the numbers in column A will always be different but the first two letters will always be either "a", "av", or "h") Can somebody help me out on a formula please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|