• 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. A

    Rolling average with bank balance

    Date DR CR Exchange Rate 1/07/2011 € 100,000.00 $0.7400 2/07/2011 € 50,000.00 $0.7550 3/07/2011 € 7,500.00 $0.7800 4/07/2011 € 5,000.00 $0.7700 5/07/2011 € 160,000.00 6/07/2011 € 100,000.00 $0.7900 7/07/2011 € 80,000.00 I want to calculate what the...
  2. A

    Goal seek to a max value

    I want to do a goal seek where the changing cell is a % but it cannot exceed 100%. Is there coding which will allow a goal seek but to a max value (if goal seek is then >100, then another line of code would activate)
Back
Top