I liked that you explained it piece by piece to see how each piece was built, and then at the end how they all fit together. This is how I would want a coworker to explain it to me. Thank you. I subscribed because I figure if I have another question like this you are the guy I want to explain it to me. 👍🏼
Fantastically helpful. Only thing that might have made it better is if you included the final formula in video description to make is copy/paste-able. But thanks, this was very useful
@@DSMStrength Sure we would! I want to know HOW and WHY not just WHAT! You'd probably get more likes if you included the formula. I know I'd give you one in that case.
Really hard to see the first part of video. I would suggest making the final formula much bigger at end of video for those old folks who are trying to write it down if you won't make it paste able. Thanks for the info.
@@tjones675 I am sorry you feel that way what is your email I will email you a screenshot of the formula in the video. I am not sure why you are unable to see the formula but I am watching the video right now myself and everything is able to be seen.
Not sure if anyone is monitoring this, but if my original number isn't a whole inch, how do I round the inches value to 2 decimal places? I've got a result of 15'11.86233894" or whatever. Can't get anything to work since our result already has so much custom stuff with the feet and inch symbols.
Use the "ROUND" function. *_=round(number,num_digits)_* Where "number" = the number (or cell or formula(e)) you wish to round off; and "num_digits" = the number of decimal places you want. For converting inches to feet-and-inches with a specific number of decimal spaces, here is the formula you will need : *_=INT(a1/12)&"'-"&(ROUND(MOD(a1,12),2))&""""_* This will return this type of result : *_12'-3.45"_* _*NB: *_ *_- Substitute *a1_*_ with the appropriate number (or cell or formula(e)) in your spreadsheet.*_ *_- Substitute the *2_*_ with the number of decimal places you want. "0" will return no decimal places.*_ I hope this helps.
This presentation was great. It served 2 purposes for me. Combining formulas and changing inches to Ft & Inches. Just awesome
Can you continue to fractions of inches please?
I liked that you explained it piece by piece to see how each piece was built, and then at the end how they all fit together. This is how I would want a coworker to explain it to me. Thank you. I subscribed because I figure if I have another question like this you are the guy I want to explain it to me. 👍🏼
Great video... I was able to successfully get this to work for my project
no problem thanks for watching
Fantastically helpful. Only thing that might have made it better is if you included the final formula in video description to make is copy/paste-able.
But thanks, this was very useful
then you wouldnt have to watch the whole video 😂
Can you put the formula in the description for easier access?
Then you wouldn't watch the video 🤣
@@DSMStrength Sure we would! I want to know HOW and WHY not just WHAT!
You'd probably get more likes if you included the formula. I know I'd give you one in that case.
Great video. How would you convert feet inches to inches?
Loved your teaching. Thanks a lot!
Thank you very much for watching
Really hard to see the first part of video. I would suggest making the final formula much bigger at end of video for those old folks who are trying to write it down if you won't make it paste able.
Thanks for the info.
You can maximize the screen thanks for watching
@@DSMStrength maximized all different resolutions YOU CANT SEE ANYTHING !!!! NO HELP thanks for smart remarks asking for information
@@tjones675 I am sorry you feel that way
what is your email I will email you a screenshot of the formula in the video.
I am not sure why you are unable to see the formula but I am watching the video right now myself and everything is able to be seen.
hi can you help me how do you convert that ft and inches to meters?? I would like to calculate it for BMI
how can one revert the formula to convert feet & inches you have in the columns into centimeters?
How do you round off to the nearest whole number, if the cell in question has decimals in it?
=mround(number, decimal)
I was hoping to get that integrated in the formula shown in the video as I have decimals in the converted row.
Not sure if anyone is monitoring this, but if my original number isn't a whole inch, how do I round the inches value to 2 decimal places? I've got a result of 15'11.86233894" or whatever.
Can't get anything to work since our result already has so much custom stuff with the feet and inch symbols.
Use the "ROUND" function.
*_=round(number,num_digits)_* Where "number" = the number (or cell or formula(e)) you wish to round off; and "num_digits" = the number of decimal places you want.
For converting inches to feet-and-inches with a specific number of decimal spaces, here is the formula you will need :
*_=INT(a1/12)&"'-"&(ROUND(MOD(a1,12),2))&""""_*
This will return this type of result : *_12'-3.45"_*
_*NB: *_
*_- Substitute *a1_*_ with the appropriate number (or cell or formula(e)) in your spreadsheet.*_
*_- Substitute the *2_*_ with the number of decimal places you want. "0" will return no decimal places.*_
I hope this helps.
How to do the reverse? Means convert ft inches to ft???
divide by 12 add the remainder?
what's the formula to convert the other way? (feet/inches into inches)
Multiply feet by 12 and add inches
@@DSMStrength right but if you have both values in one cell (6' 3") how do you do that in a formula?
@@MasterZhao i have same problem but i want to convert it in meters so that i can convert it together with the weight for BMI calculation