98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Low Priority · Version 2003
Wed 4 Feb 2009, 09:32Delegate Bob said...
Bob has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel VBA
In reality when should a double be used instead of single?
Wed 11 Feb 2009, 12:52Trainer Carlos said...
RE: Excel VBA
Hi Bob
A variable type Single will hold pretty large numbers.
Bu as a default excel treats numbers entered into worksheets as Doubles.
I have talked to some people who say the extra precision Doubles provide means most algorithms don't need to be optimized for prevention of rounding error. This means that if you use Doubles the numbers will be more accurate in the long run.
So the general consensus is that although Double takes up more memory space it deals with the numbers faster and more accurately than Single
Hope this helps
Carlos
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use the SUBTOTAL function in ExcelYou can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this: |
