Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up whole dollars only
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 -- Thanks Mike T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count dollars in related cells | Excel Discussion (Misc queries) | |||
How do I convert euro to us dollars in excel? | Charts and Charting in Excel | |||
Adding dollars | Excel Worksheet Functions | |||
Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
Separating dollars and cents | Excel Worksheet Functions |