It is slow, but you never get decimal error creep. Most modern computer programming languages have this (in Java it is called BigDecimal). Maybe someday Excel will permanently solve this problem by adding a Binary Coded Decimal data type. This is, however, a huge problem in many other non-InchCalc spreadsheets (pretty much all financial spreadsheets that do math on currencies have these errors hiding in them- often leading to WRONG answers). This is not too much of a problem for InchCalc since most people by convention specify inches in fractions (1-3/4" rather than 1.74"). Ultimately the solution is to not use decimals unless they are an even power of two in the denominator (0.125 is ok, 0.100 is not). H ttp://supp ort.micros oft.com/de fault.aspx /kb/214118 You can read the Microsoft Knowledgebase article here I could make InchCalc hide this problem from you by rounding in the incoming inches to, say, 10 decimal places but I generally prefer to have things fail quickly and explicitly rather trying to hide the problem only to have it show up unexpectedly in a seemingly unrelated cell. You might be very surprised to see that the answer is NOT zero. Try typing the following formula into Excel (any Excel spreadsheet, InchCalc *NOT* required) (But you can preserve the decimal number in a hidden field for calculation purposes.) If you want the ft and in in one field, then you have to give up the number quality. Just put whatever text you want in quotes, and remember double quotes inside double quotes will not work.
You can use the ' and '' (use two single quotes) marks if you like, and you can also put a - before the inches. Format Cell -> Custom -> type in the box or if you want the space first. If you're not picky, and you're just looking for presentation, then you can use custom formatting to make them look correct. You now have one column with the feet, another with the inches. Extracting the feet involves the INT formula: =INT(A1/12). Assuming 98 inches is in cell A1, that formula will return a value of 2. You can create a column with just the inches component by using the formula: =MOD(A1,12). 98/12 = 8 1/6.)Ĭonverting 98 inches to 8'2" however is achievable in a few steps, but the output will be a text field, not a number field. If you pick the "up to two digits" type (and don't force 8ths, 16ths, etc.) then Excel will magically conver to the simplest fraction. Excel has a built-in "fractions" number type.
0 kommentar(er)
