I'm hoping someone can post the formula I would input into a cell to calculate true position from 2 pieces of data.You need to provide more details than the above if you expect to get an answer to your problem. One thing you must keep in mind when you ask a question in a forum. The people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result. You must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to 'figure it out' on our own.

• True Position Formula

Remember, you are asking us for help. So help us to be able to help you by providing the information we need to do so, even if that information seems 'obvious' to you (remember, it is only obvious to you because of your familiarity with your data, its layout and the overall objective for it). Assuming the two cells are A1 and B1, put this formula in, say, cell C1.=2.SQRT(A1+B1)Sorry to revive such an old post but this came up as a top response when googling 'True position formula for excel'. I just wanted to point out to anyone else that ended up here that unless your excel columns for delta to nominal are already squared then you have to square them in the formula:My Column A contains the delta from measured value for X position and Nominal value for X positionMy Column B contains the delta from measured value for Y position and Nominal value for Y positionThe formula that works to calculate true position for this data arrangement is:=2.SQRT((A1.A1)+(B1.B1))Hope that helps. (23 responses) Hi - I'm creating a userform where I'd like to have about 10 checkboxes. How would I go about creating another check box that woul.(13 responses) Is there anyway to have a selection list to choose from instead of writing a comment in the comment box?

True Position Formula

Here is what I would like to do: If.(13 responses) I'm looking for a script to delete any sheets that meets the following critera and without promtp: If sheets contains the text: 'P.(12 responses) Can someone please help me? I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special techniq.(10 responses) I have a workbook with 468 sheets of data. Each sheet has a table in the range of A4:AA500. I need to create a named range for each of the t.The Holy Grail of Excel Tips $12.60.

Let's say you're trying to hit dimension 0,0. But you really hit dimension 3,4.

Through the Pythagorean theroem and such you do the formula SQRT(x squared + y squared) to find the hypotenuse and you end up off 5 from your intended 0,0 target.However, the way true position callout works, the formula is 2.SQRT(x squared + y squared), thus putting you off 10 (even though we just established that you were really only off 5).Anyone know why they double the number to get true position?Look on the true position callout - see if the true position tolerance number is a diameter or a radius. If it's a diameter, there you go - a.010 diameter true position is only.005 in radius. So you can either A) half the tolerance when you do the math, or B) just double your number.So, if the magnetude/hypotenuse of the errors comes out to be 5, and the tolerance is a.010 diameter, you've just taken up all the allowable error.Edit: Ooops, didn't see bobw's answer. Don't forget that the hole tol.

Can add to or tighten your true postion needed also. On a hole sized.5' +/-.010' making the hole.510 adds adds that.010' as a bonus to your true postion number.SteveA Hole size tolerance can only give you bonus tolerance If and ONLY IF you're given MMC. Boring a hole.5' +/-.010' to.510 with MMC adds.020 to your TP (not.010).In other words, for a hole.500 +/-.010 has TP of Dia.010 at MMC (.490) If you bore the hole to LMC (.510) you get.020 bonus giving you a grand total of TP Dia.030Side note: +/-.010 on a hole of.500 in my shop is like throwing a hot dog down a hallway. Bonus tolerance is more important with closer size tolerances. (+/-.002 or less)-CEM.