Hi there Forum Members, I am glad to have found this forum as I am getting into Excel "Magic"
I have been working with Excel for a few years and I am still a beginner. But that's okay, each time I learn something new I get excited as a child getting a new toy. I call myself a novice though about two years ago, I created a huge spreadsheet for the company I was working for, that became the main document to be filled out in sales department.
Today, I was working on another huge spreadsheet when I encoutered a issue which I wasn't able to solve by myself. Please, experts, give your advice if a formula is possible.
If a cell in column A contains a chosen text then add a certain value to the next cell in column B. In column A I have dates for multiple years and in column B I have currencies. Once a month I want to feed the account, which is yielding interest compounded every day, with a certain, same amount.
Thank you!
Bookmarks