Stack Exchange network consists of 182 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I just created this question. I tagged it excel, because the formulas are roughly analogous.
I added the tag and made your question more readable. Not sure if it is necessary to write an answer but you might want to explain, what you mean by but then it doesn't work as expected.