So I kind of feel embarrassed because I'm trying to make an unbreakable Excel spreadsheet for society treasurers of the future (who may have never coded an if then statement in their lives) and I couldn't get an Excel function to work properly so I ended up making a thread on Stack Overflow and only now does it turn out the bloody thing wasn't copying right so the coding I stuck on Stack Overflow works but I'm way too embarrassed to go back to it and say that it wasn't any coding that was the problem but my own inability to click and drag down properly. And knowing my luck, the next treasurer will break it forever. I have stuck my email in for future use and will stick a how-it-works sheet in for future treasurers. Just so long as they don't fiddle with the code it'll work fine.