I am trying to create a formula that will read a range of credit card numbers
and separate out M/C and Visa, then look at the amount in the corresponding
line different column, and put the total into a given spot for visa and
another spot for M/C.
I know that I can seperate using less than or greater than 5000 0000 0000
0000.