need values for tolerance

I am putting together a Quality Sheet for checking parts and I am having trouble getting a formula to determine what the tolerance would be (min-max).

Example:
In B12 my Ideal measurement is 7.806"
In B13 I have my +/- .015"

In B14 I would like to have Excel give me 7.791" - 7.821" based on a formula.

I am new to formulas (other than easy ones) in Excel and I am sure there is a way but I have spent way too long trying to figure it out.

Any assistance would be great!
Thanks!!
JLV7812

In B12, use this Custom format: #.000\"
Enter 7.806 in the cell and it should display as requested.

In B13, use this Custom format: "+/- "#.000\"
Enter .015 in this cell and it should display as requested.

Formula for B14: =(B12-B13)&CHAR(034)&" - "&(B12+B13)&CHAR(034)

Hope that helps!

Hi Tony,

Not always but I believe most of the time. I have gone in and separated the cells to remove the " symbol and also separated the +/- from the nominal (2 separate cells).

From there I am able to get it to work. Just very tedious.

Originally Posted by minnesotaart

In B12, use this Custom format: #.000\"
Enter 7.806 in the cell and it should display as requested.

In B13, use this Custom format: "+/- "#.000\"
Enter .015 in this cell and it should display as requested.

Formula for B14: =(B12-B13)&CHAR(034)&" - "&(B12+B13)&CHAR(034)

Hope that helps!

I will try this and report back. Thanks!!

Will B14 require a custom format as well? It is just filling in my formula

Did you type the = sign at the beginning of the formula?

Yes Here is my formula (Different part of spreadsheet) =(b49-B50)&CHAR(034)&" - "&(B49+B50)&CHAR(034)

That should work. Is the format for that cell (assuming b51) "General"?

That was the trouble.....it was set as "Text" Thank you SOOOO much for your assistance!!

My pleasure. A fun little exercise. Be sure and mark the thread as Solved.