• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Array formula with nested functions issue

    Thanks! That works perfectly, I was unaware that the AND function wouldn't work with arrays, is that the case for other functions as well? Regards, V
  2. V

    Array formula with nested functions issue

    Please see the following file: https://dl.dropbox.com/u/32020573/121023-Exchange%20rate.xlsx I have been trying in vain to write a formula that finds the average exchange rate value for the period spanning a full year before a specific date. When the specific date in question is the last day...
Back
Top