Calculation for excel

[engrdcatinhere]

I have a project or needs a report to calculate and it goes something like this, i have to calculate the total amount of points earned by a customer when using a rewards card. this is used (card) to earn/accumulate points, for every 50.00 pesos is equivalent to one point. I have to calculate the total points earned for each activated cards after three transactions, i have thousands of activated cards. not sure how will i calculate these given data....... hope to hear from someone soon...thank you!!!!

 

[fairwinds]

Hi,

As I see you also posted this in General forum, I'll lock this one.
http://www.mrexcel.com/board2/viewtopic.php?t=275436&highlight=