G
Guest
Hi all
I am trying to add up my credit card points for each transaction i make,
problem is points are only counted for whole dollars, for example a
transaction of $82.50 will earn 82 points, $100.95 will earn 100 points and
so on, to further complicate matters mastercard earns 1 point for every
dollar & our Amex card earns 2 points for every dollar, example for an Amex
transation of $175.95 will earn 350 points ($175x2), the cents are not
calculated.
Example of database so far
Column G = dollars spent
Column J = Mastercard or Amex ( I enter an M or an A here)
Column L = Points, formula i have so far is =IF(J6="m",(G6*1),IF(J6="a",G6*2))
G6 = $82.50, J6 = M, L6 = 82.50 (this should read just 82)
G7 = $100.95, J7 = A, L7 = 201.90 (this should read just 200)
I hope this all maks sense
I am trying to add up my credit card points for each transaction i make,
problem is points are only counted for whole dollars, for example a
transaction of $82.50 will earn 82 points, $100.95 will earn 100 points and
so on, to further complicate matters mastercard earns 1 point for every
dollar & our Amex card earns 2 points for every dollar, example for an Amex
transation of $175.95 will earn 350 points ($175x2), the cents are not
calculated.
Example of database so far
Column G = dollars spent
Column J = Mastercard or Amex ( I enter an M or an A here)
Column L = Points, formula i have so far is =IF(J6="m",(G6*1),IF(J6="a",G6*2))
G6 = $82.50, J6 = M, L6 = 82.50 (this should read just 82)
G7 = $100.95, J7 = A, L7 = 201.90 (this should read just 200)
I hope this all maks sense