View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis
 
Posts: n/a
Default 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