Hi All,

Sorry if this has been asked before. I’ve a bunch of cards such as Amazon, Amex Gold, John Lewis and I am trying to work out which gives the best return.

Amazon say for every £2 you get three points for Amazon Purchases and 1 point for every £2 elsewhere (at 1000 points you get a £10 voucher)

Some cards talk about 0.5% cashback and others give rewards etc.

I’m trying to write an excel formula(s) that basically works out the rewards yield or how much you have to spend to get the value of £x and also in reverse - if you spend X this is what you can get back if you use this card.

I know to take into account membership fees etc, but I’m struggling to workout the formula to workout the value of a point in order to compare my cards?

Does that make sense, so I guess I’m trying to create a cashback/rewards calculator. (I know there are online ones - but I want to code all the different schemes here)

Thanks in advance…

M