Hello,
At work, we use a spreadsheet containing credit card numbers. Based on the card number, we will then enter MC/Visa into another cell if the card is either one of those, or enter AMX if the card number is an American Express number.
Visa cards begin with the number 4. Mastercard begins with the number 5. American Express cards begin with 3.
Unfortunately, we have to enter the entire card number into the cell, can't just enter the first digit.
Is there a way to have cell a3 return "AMX", if a number beginning with 3 is entered into cell A1?
Conversely, can cell A3 return "Visa/MC" if the number beginning with 4 OR 5 is entered into cell A1?
Thanks.
Bookmarks