Excel Formula Help

[$tephen W.]

Hello, I need help with the following excel formula. If a credit cards is 1234...5678 how do I create a formula to say if the first number =1 then call this mastercard or if the first number is 2 call this visa?

Thank

 

[VoG]

Try

=IF(LEFT(A1,1)="1","Mastercard",IF(LEFT(A1,1)="2","Visa","")

 

[$tephen W.]

The formual still does not sum.. This is what it looks like.

<TABLE style="WIDTH: 385pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=513 border=0><COLGROUP><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 319pt; mso-width-source: userset; mso-width-alt: 15542" width=425><TBODY><TR style="HEIGHT: 15pt" height=20><TD id=td_post_2677265 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 66pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=88 height=20>3772...3006</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 319pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=425></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">=IF(LEFT(A1,1)="1","Mastercard",IF(LEFT(A1,1)="2","Visa","")

</TD></TR></TBODY></TABLE>

 

[scottylad2]

=IF(LEFT(A1,1)="1","Mastercard","Visa") if you only have 2 options, Vogs formula can be trimmed slightly

 

[scottylad2]

The formual still does not sum.. This is what it looks like.

<table style="WIDTH: 385pt; BORDER-COLLAPSE: collapse" border="0" cellpadding="0" cellspacing="0" width="513"><colgroup><col style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width="88"><col style="WIDTH: 319pt; mso-width-source: userset; mso-width-alt: 15542" width="425"></colgroup><tbody><tr style="HEIGHT: 15pt" height="20"><td id="td_post_2677265" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 66pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height="20" width="88">3772...3006</td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 319pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width="425">
</td></tr><tr style="HEIGHT: 15pt" height="20"><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height="20">
</td><td class="xl65" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">=IF(LEFT(A1,1)="1","Mastercard",IF(LEFT(A1,1)="2","Visa","")

</td></tr></tbody></table>

are you looking to sum say all the mastercards in column? then have something similar for Visa? your original post stated you just wanted to have the word mastercard or visa.....can you clarify

 

[scottylad2]

something like this?

Excel Workbook
	F	G	H
2	Ref Number	Amount	Card Type
3	1123456814	19.00	mastercard
4	2123456792	162.00	visa
5	1123456804	256.00	mastercard
6	1123456819	520.00	mastercard
7	2123456843	466.00	visa
8	2123456826	442.00	visa
9	1123456831	466.00	mastercard
10	1123456847	281.00	mastercard
11	2123456789	629.00	visa
12	1123456840	240.00	mastercard
13	2123456808	288.00	visa
14	1123456794	527.00	mastercard
15	1123456842	602.00	mastercard
16	1123456802	95.00	mastercard
17	2123456794	211.00	visa
18	2123456820	370.00	visa
19	1123456822	272.00	mastercard
20	2123456790	475.00	visa
21	2123456817	476.00	visa
22	1123456850	629.00	mastercard
23	2123456831	556.00	visa
24		Mastercard	3907
25		Visa	4075
Array Formula Option

with Vogs formula to designate the card type