Find nearest value
Perhaps if you wish to work with an accuracy of say 1/(2^16) (1 / 65536)
then maybe ...
Numerator: =ROUND(A1*65536,0)
Denominator: 65536
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"Two-Canucks" wrote in message
...
Formating the data as Fractions Up to three digits
does not help.
I need fractions in this format:
1/2^1; 1/2^2; 1/2^3; 1/2^4; 1/2^5; 1/2^6; 1/2^7;
i.e. Imperial measurements.
--
Occasionally stumped
"Gary''s Student" wrote:
Format the data as Fractions Up to three digits
--
Gary's Student
"Two-Canucks" wrote:
I have a column with diameters in thousands of an inch.
I need to find the nearest equivalent in fractions such as 1/64 1/128.
The
fractions show as decimals in another column.
The fractions format only goes to 1/16 which is not small enough.
The match function gives an error.
Many thanks
--
Occasionally stumped
|