07-04-2009, 07:28 PM
|
 |
Forum Guru
|
|
Join Date: 21 Mar 2008
Location: Bakersfield, CA
MS Office Version:2003 (can read 2007 files)
Posts: 9,517
|
|
|
Re: Calculate Button
Quote:
Originally Posted by martynduerden
As for the reasoning I am writing a program, and I have created a data entry sheet I wanted the button as not all the program users will know that F9 is calculate
|
1) A note on the sheet "Press F9 to calculate" pretty much educates new users.
Quote:
|
...and on auto calculate all the result cell's have Divide by 0 errors.
|
2) Any formula that divides by a cell that could be empty should be rewritten. If the formula =A1/B1 gives an error when B1 is empty, evaluate cell B1 first....like so:
=IF(B1=0,"",A1/B1)
That technique can be adapted to solve most equations that result in errors when data is missing. It's a habit worth getting into and is far more useful than turning off calculations and hope you/others remember to update by pressing F9 or a button.
My two cents. 
__________________
If you've been given good help, use the  icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
|