Spreadsheet example |
Since he was writing for eHow, Carter had to pad his text to reach the DMS minimum word count; which probably accounts for the inconsistency of statements like
"Microsoft Excel does not have any functions that explicitly convert decimals to feet and inches. However, you can use other Excel functions to make the conversion for you. In order to make these connections, you need to remember that there are 12 inches in a foot, so if you have a decimal, you need to convert it to a fraction of 12. For example, if you have 0.5 as your decimal, then as a fraction of 12, you have 6/12, or six inches."Duh. Of course, we aren't sure which "connections" McBride expects to make... The combination of McBride's semi-competence and the site's insistence on a standardized format force Carter to begin his instructions (including the required "action verb") with
"Open a new worksheet in Microsoft Excel..."We repeat, "Duh." But when Carter gets to the true meat of the matter, he... let's just say his padding turns into overcompensation:
"In cell C1, type "=(((A1-INT(A1))12)/10)10." This is the formula to convert your amount in feet to inches. In the example, cell C1 will display 10.8 because 0.9 feet equals 10.8 inches."Now first, we have to translate eHow's idiotic typographical conventions for formulas: in the original version, according to the Wayback Machine, the formula Carter used was (((A1-INT(A1))*12)/10)*10Either way you type it (using standard symbols or just using typographic stupidity), though it's... well, it's not quite right. You see, Carter wants you to divide the decimal portion of the original number by 10 and then multiply that answer by 10 – a waste of time, since the division and multiplication steps cancel each other out. Oops. |
For what it's worth, McBride obviously doesn't know much about Excel, because your answer becomes two numbers. If you really want to convert the decimal 12.8 feet to feet and inches in an Excel spreadsheet, all you have to do is:
- Type 12.8 in cell A1
- Type =INT(A1) in cell B1
- Type =(A1-INT(A1))/12 in cell C1
- Type =CONCATENATE(B1," feet, ",C1, " inches") in cell D1
¹ The original has been deleted by Leaf Group, but can still be accessed using the Wayback machine at archive.org. Its URL was ehow.com/how_8343535_convert-decimals-feet-inches-excel.html
copyright © 2016-2022 scmrak
MM - SOFTWARE
No comments:
Post a Comment