• 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

    How to keep a cells sum value constant while changing the other cell values

    Thank you for your help. However, it doesnt show up on my sheet. I would like to have the date and time visable in a cell on the sheet.
  2. A

    How to keep a cells sum value constant while changing the other cell values

    Thanks! it worked I entered the formula for Hshold as =752-SUM(B20,D20,D21,D22,D23). I figured it was something simple. Iam a novice user at Excel and dont use it frequently. I have another question, Let me know if I should I post it or would you be able answer it?: How can I insert a "last...
  3. A

    How to keep a cells sum value constant while changing the other cell values

    @ Luke M My thinking is that I want only the Hshold value would Auto Adjust to keep the 752 sum. So for instance if I changed Bill-1 to 170 (up by 5), then only HsHold would Auto adjust to 110 (down by 5), to still keep the total SUM 752.
  4. A

    How to keep a cells sum value constant while changing the other cell values

    I have Excel 2010. Is there a formula for the following? Here is my example: 116 Bill 1 165 Bill 2 160 Bill 3 170 Bill 4 26 Hshold 115 752 752 is the SUM of all the values. If I manually change the 116 and/or one or more of the Bills values, AND I want only the Hshold value to auto adjust to...
  5. A

    Hello .. Introduce yourself

    Hello everyone. Im hoping to learn a bit of Excel. I dont use it frequently, so Im only somewhat familiar with all of its functions. Thank you
Back
Top