Forum Discussion
Create monthly and yearly costs based on 2 columns
Hello, I have a Excel sheet like below for my subscriptions and want to figure out Monthly and Total Yearly costs. Some services are paid 12months in advance vs 6 and some are just monthly. I guess...
You're making it much more complicated than necessary. There are no doubt multiple solutions, but here's the one I'd use for simplicity's sake. Just create a small table of conversion factors and use VLOOKUP to determine which is the relevant one. I've attached the actual file, but here's an image as well.