I am finding that the VBA Round function returns the wrong result. I found a working alternative which is to use the Application.Round instead.  Why doesn't the VBA Round function work as expected?  Sub roundingResults()     Range("A1") = 123456.705     Debug.Print "Approach #1 " &amp; Round(Range("A1").Value, 2)     Debug.Print "Approach #2 " &amp; Application.Round(Range("A1").Value, 2)     End Sub   Output  Approach #1 123456.7 Approach #2 123456.71
I had an application for returning closest matches to certain values in a large  cluster of values( as in my earlier )   and I chose a VBA solution. While in the course of using the said application, I observed that the results for the value of 0.5 were not correct. I had been using the VBA Round function which I found to be returning 0 for 0.5 rounded to integer whereas the worksheet round function returns 1. Strangely, the VBA round function returns 2 for 1.5. I had to substitute the worksheet function in place of the VBA one.  Am I missing something?
Viruses in wine? Is the closure of path-connected set path connected? Is the following sentence correct English?      Have you the address?   The address in question is obvious to the person being asked.  It's normal to ask such a question as "Do you have the address?" or even "Have you got the address?" But is it acceptable to use just the verb have without do or got? Defaults to true.  If set to true replaces all instances of known swear words with replacements (comical or * based). If false renders the content as originally presented.  Benefits:    Reduces moderation requirements necessary to ensure that people behind corporate firewalls are not blocked by an errent swear word.   Stops idiots like me complaining about it. What is the meaning of 'though'? Okay, of course I've used different popular online dictionaries and the translation makes sense in the most cases.    Sometimes I find usages of 'though' where I don't get the meaning of the word.   An example I've found on twitter     That face, though. [Image of a dog looking weird]   The tweet came without any context or conversation.  When I translate this example to my native language - german - this makes absolutely no sense. At least for me.  So is the above usage some kind of slang? What is the meaning of though in this case?  For the completeness an example that makes absolutely sense for me     Though he tried very hard, he failed the course. Inequality involving sides of a triangle How can one show that for triangles of sides $a,b,c$ that   $$\frac{a}{b+c}+\frac{b}{c+a}+\frac{c}{a+b} &lt; 2$$  My proof is long winded, which is why I am posting the problem here.   Step 1: let $a=x+y$, $b=y+z$, $c=x+z$, and let $x+y+z=1$ to get   $\frac{1-x}{1+x}+\frac{1-y}{1+y}+\frac{1-z}{1+z}&lt;2$  Step 2: consider the function $f(x)=\frac{1-x}{1+x}$, and note that it is convex on the interval (0,1), so the minimum of   $\frac{1-x}{1+x}+\frac{1-y}{1+y}+\frac{1-z}{1+z}$  is reached when the function takes the extreme points. i.e. $x=y=0, z=1$.    But going back to the fact that this is a triangle, we note that $x=y=0 \implies a=0$ which is not possible, so the inequality is strict. Not flying the first leg of the journey – Company cancels the second-leg ticket I've a friend that booked a round-trip journey. He booked A-to-B and B-to-A. Somehow he needed to be earlier at location B, so he took a train and did not take the flight from A to B.  When he went to the airport to take the "back home" flight (B-to-A), he was informed that his ticket was canceled because he did not take the A-to-B flight. They canceled the ticket and sold it to someone else.  Is this normal? The company said it was their right to do so, and he could not get the flight back. The company was Iberia. How can I cast int to enum? How can an int be cast to an enum in C#? I have heard from  that stable orbits (ones that require a large amount of force to push it significantly out of it's elliptical path) can only exist in a three spatial dimensions because gravity would operate differently in a two or four dimensional space. Why is this? jQuery Validate Plugin - How to create a simple custom rule? What's the English equivalent of the Japanese saying, “A fart ruins 100 days of sermons by the priest (bishop)”? I was amused by the expression "Paid a penny and only farted" (related by @FumbleFingers), which suggested a similar Japanese saying: 大山鳴動鼠一匹 - "Find only a small mouse coming out after hearing rumblings and experiencing shaking of the big mountain."  It’s humorous. I chuckled when I read it, and I wrote to the author that I love it.  With that said, the word "fart" reminds me of another Japanese proverb, 百日の説法屁一つ- "A fart ruins 100 days of sermons by the priest", which means that a small mistake (the sound of a fart in front of the congregation) brings all his efforts to naught.  It can’t happen in big Western churches. But it could well happen in a small wooden temple where a priest would preach to 30 – 50 provincial followers. Can you imagine how the proud priest being called 'the venerable' would be embarrased when his loud fart is heard by all his followers during his serious sermon and they start to giggle here and there in the hall?  We also have a similar saying" 九仞の功を一簣に欠く, which literally means "Collapse a 9- meter sand tower with the last pile of sand."  What is the English equivalent of the saying "A fart ruins 100 days of sermons by the priest (bishop): a small mistake depreciates the value of (vitiates) all labor and effort to naught," preferably in such a humorous way? How to upload files to server using JSP/Servlet? Short harvard citation? I need to cite the following way:  The first 3 Letters of the author + the year.  Example:     Kemper 2009 --> [Kem09]   But I don't have any clue how to do that! If $l$ and $n$ are any positive integers, is there a  proof of the identity     $$\sum_{k=0}^{n}(-1)^{k}\binom{n}{k}(l-k)^n=n!\;$$   which uses the Inclusion-Exclusion Principle?  (If necessary, restrict to the case where $l\ge n$.)    This question is closely related to   and also How do I view all available HDD's/partitions? How to create vector graphics In Photoshop? I know people prefer using CorelDraw or Adobe Illustrator, but I want to know if there is a technique I can follow to use Adobe Photoshop to make vector Images. Switching between windows with scroll wheel on Ubuntu Dock What is the word for when someone is overly nice and actually isn't nice at all? What is the word for when someone is overly nice and actually isn't nice at all because of the unnecessary added information/comments? For example, they will say things like "Your hair looks so good that wayyyy omg you should do it that way ALL the time! Looks way better than how you usually do it." And the word I'm looking for is not passive aggressive and it is not sarcasm. There is a word for these types of people. What is it? These people think they're being kind but actually blunt and rude. Another example would be for someone to say "hey you're beautiful, but maybe if you didn't wear harsh makeup you would look better" and they intend to sound like they're being nice when you know they don't like you and are saying in out of spite. I am currently thinking about open-sourcing a project of mine and am in the process of preparing the source code and project structure to be released to the public. Now I got one question: how should I handle the signature key for my assemblies? Should I create a new key for the open-source version and publish it along with the other files to the SVN repository? Should I leave the key out and everyone who wants to compile the code should generate his own key?  How do you handle this? I feel a little bit uncomfortable with releasing a signature key to the public. Proving that the difference of the terms of a sequence, multiplied by $n$ converge