Hello All!

I work for a company that services 14 states and has a large marketing database. I have been put in charge of gathering information for our advertising in the YellowBook directories. Here is the problem that I am having:

-We have monthly payments that we make to YellowBook each month, and for an annual total, we multiply that amount by 12. (Ex. $10 per month, $120 annually.)

- We need a way that we can find the remaining balance for a particular listing by judging how many months that are left in the advertising period, or by selecting a certain month from a drop-down list. (Ex. Advertising Date Start: 01/01/08. Annual total: $120. What is payoff for that listing in June, or 6 months into the advertising contract? Answer: $60

I am familiar with a few Excel functions, but am in no way an expert on the program. Can anyone help me with this problem? I have rattled my brain away for 3 days trying to come up with logistics, but I don't know enough about Excel's functions to be able to come up with some ideas. If you have any ideas or solutions, please reply to this post or e-mail me directly at: [email protected]

Thanks in advance!

-Josh Wright