• 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


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

Value returns value of 1 not zero per formula


New Member
I am calculating an increase rate. If I enter 0% in column E, the new rate in column J should equal to column I, but is giving me higher value of +1. Would you PLEASE assist. Please see worksheet attached.


  • Rate.xlsx
    14.3 KB · Views: 3