I am creating a spreadsheet for my credit card rewards.
Up to 1500 dollars, the card earns 5x points (Per Quarter). After that it earns 1x points.
I am trying to figure out how to calculate this. I can figure it out for the first month but then to carry it over to the next two while keeping track of the previous month is where I'm getting hung up I think
If A VBA is not necessary, IF formulas are fine.
I'm sure I'm way over thinking this process but any help would be greatly appreciated. Every time i think I have it, something is missing.
Bookmarks