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

    Percentage calculation problems [SOLVED]

    Many thanks Stephane. This solved my problem. Its strange that I have not come across this sort of error before.
  2. R

    Percentage calculation problems [SOLVED]

    Tried this but it doesnt seem to work. The spreadsheet has some weeks when both weeks are negative, some when both are positive and some where either the first or the second week is negative. A colleague has suggested that I need a nested IF statement. He's working on it now. I'll let you know...
  3. R

    Percentage calculation problems [SOLVED]

    Hi, first post so forgive me if this has been covered elsewhere! I have a spreadsheet that looks at two cells and calculates the % variance. The difficulty I am having though is that some of the cells are negative figures and this seems to be throwing out the results. Example: Value 2008 =...
Back
Top