Excel 2010 Function Improvements
November 12, 2009 • JP • No Comments • Rate This Article
• Links to this article
In Going Back to the Topic of Functions For a Moment…, Excel Program Manager Joseph Chirilov posted a PDF containing information about improved functions in Excel 2010. These changes were introduced in a previous post on the same blog. Some functions have new names to make the interface more consistent, while others are becoming more accurate.
There are a few functions I'm most concerned with that supposedly will have a better algorithm. I've used all the other functions a combined total of 0 times.
Improved Functions in Excel 2010:
- MOD
- RAND
- CEILING
The problem is, the PDF attached to the blog post doesn't explain exactly how these functions will be improved. I did find a reference to bugs in the MOD function (see Mod Bug), but didn't find anything for the other two, and I can't confirm if the Mod bug is fixed in Excel 2010. So we'll have to wait and see if any explanation is forthcoming.
For an explanation of how these functions work, and more, check out Chandoo's Excel Formula E-Book. (note: this is an affiliate link)
Excel ·
Rate This Article:
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Where's the link love?
Next Post: Spotlight: Free Outlook Productivity Tools
Speak Your Mind
Tell us what you're thinking...Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].