Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Excel: How to Perform Automatic Addition and Reseting under certain co

  • Please log in to reply




  • Member
  • PipPip
  • 92 posts
I'm trying to create basically a substitute for those expensive "Chores"/"Children's Behavior" programs using Excel, and my inexperience in formula manipulation is showing. How would I be able to tell Excel the following?

IF A1=25 (this is after chore is done 25 times), then automatically add 50 points to B1 and reset A1 to 0.

I hope this isn't too complicated (or confusing for you to understand), but it would help me out a lot. Thanks.
  • 0




    Retired Staff

  • Retired Staff
  • 2,459 posts
I was hoping one of the VBA guys would chime in on this....

Anyway, my solution is attached. The calculations/evaluations for number of chores and points accumulation are done in E & F. Then I set up a macro to copy the contents of cells E & F and paste the values into B & C, so don't freat out if you get a macro warning when opening the excel doc. I envision entering the updated number of chores done daily (or whenever), then immediately running the macro to evaluate and replace the cells.

I had to zip the file, so if you need a zip program, I recommend Zip Genius. You can download it here: http://www.zipgenius...eng/?page_id=10

Let me know if this helps or if you have any questions.

* LindaGail wishes mightily she knew more about VBA
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP