Hello Friends
Why I am getting '0' answer while using this formula. What wrong I am doing herPlease Login or Register to view this content.
Hello Friends
Why I am getting '0' answer while using this formula. What wrong I am doing herPlease Login or Register to view this content.
I can't tell why you are using FormulaArray instead of Formula, but you do have a syntax problem. I can't test it without your file but try this:
Please Login or Register to view this content.
This is what I get when I run the code
My Answer is ZeroPlease Login or Register to view this content.
It is working now. The problem was with the name. I was using 'mymnths' instead of 'mymnth'. So silly.
But, thanks for the help.
I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks