I saw some people having an issue with this in the comments so I tried it myself and found the following: You have to actually click the A1 cell when he does it during the creation of the formula. You can't just input the line of code. If you skip this step and just try to paste in the code without clicking the cells you will get an error. Step 1: Format Column A as text Step 2: Click cell A1 and enter in "12-5+7/8" Step 3: Click cell B1 and select Formulas>Name Manager Step 4: Click New on the Name Manager and input "ftin" for the name Step 5: Click cell A1 Step 6: Paste =EVALUATE(SUBSTITUTE(Sheet1!A1,"-","*12+")) into the Refers to: field and press close Step 7: Click in cell B1 and enter "=ftin" When you follow these steps exactly, it turns B1 into the decimal form of the input from A1. You can now plug anything into A1 in the format of feet-inches+fraction and it will update B1 to show the decimal equivalent.
finally got it to work. Thanks. I followed another tip in the comments that said the you must/should click on the cell when creating the evaluation function. Cant just type in the coordinates.
I FOLLOWED THE STEPS AS EXPLAINED IN THE TUTORIAL. I TRY TO ENTER THE FORUMULA AS USUAL AND I KEEP GETTING =FTIN. I ALSO TRIED THE SUGGESTION FROM MATT HAND AND I GET THE SAME RESULT. I HAVE OFFICE 365 IF THAT HELPS. THANKS
Thanks for this. Is there a way to get it to ignore an inch symbol if I wanted to use the input string of 12'-5 7/8"? I know I can include the foot symbol ' in the substitution string, but i am trying to figure out if I can get it to ignore in inch symbol at the end instead of erroring out.
What would the inverse of this be? After adding many converted (ft-in+fractional) entries, I am trying to show the summation as a total length back into (ft-in+fractional) from. Great video, thank you.
I would like to create a table where i can enter the measurements (feet and inches) of what the material is supposed to be and have it calculate automatically if i am over or under the 1/4 in tolerance. For example: if a skid is supposed to arrive 66ft X 44 1/2 ft and but the material i received is 65 5/16 ft X 44 1/16 ( I would like for it indicate whether i am over or under tolerance) Thanks in advance
@@NicholasCoffee this all I have at the moment, but this is the formula that we go by L:55 1/2 X W: 80.3/4 but then again, each sheet is different but if create one to match this one then it would be just a matter of making small changes to others
Can't get it to work, keep getting name or value errors, I can't seem to isolate the cause, wish I could get it to work. Thanks for the awsom tutorial, I'll keep plugging away in the hope I can fix it cause it shur would be useful.
There are actually really good arguments for both a base 12 and base 16 measurement system in construction. While design professionals enjoy metric, in the field where equally spaced items are necessary there's a lot of value there.
