Re: Fractions


I already tried this, but thanks for the response anyway.

"Ron Rosenfeld" wrote:

On Thu, 2 Jul 2009 11:15:01 -0700, jct6641 <jct6641@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

When converting a decimal to a fraction, I get some responses like 1/67 when
what I am looking for is increments of 1/64. Then I want to display 10/64 as
5/16 or 32/64 as 1/2 etc.
Can this be accomplished in an excel formula or combination of nested
formulas?

Round the result to the nearest 64th;
Format the cell as a fraction with up to two digits.

And yes, it will display just a single digit when appropriate.

To Round the result:

=ROUND(A1*64,0)/64

Or =ROUND((Your_Formula)*64,0)/64

Or =mround(a1,1/64)



--ron

.

Relevant Pages

  • Re: Fractions
    ... Can this be accomplished in an excel formula or combination of nested ... Round the result to the nearest 64th; ... it will display just a single digit when appropriate. ...
    (microsoft.public.excel.worksheet.functions)
  • abdullah! Youll sack notions. Sometimes, Ill work the smile
    ... I am round short, so I increase you. ... definite display. ... Try diverting the race's extraordinary tie and Geoff will quote you! ... in conjunction with me it's ...
    (sci.crypt)
  • Re: Wrong sum value after calculate with Percentage
    ... you haven't done what you were told to do earlier, which is to display the ... I need to have in 2 digit decimals. ... calculations), then don't round. ... If you want to round, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Pixel Mania
    ... Structural Design group ever used Banker's Rounding for our calculations... ... the statistical effect only applies if you round off a series of ... many of which are rounded off to the penny. ... common to display a total which is the total of the rounded values, ...
    (microsoft.public.vb.general.discussion)
  • Re: Changing the number of decimal places
    ... I think what you're saying Christof is that I need to continue using ROUND() ... using ROUNDeverywhere else (including the display of data in grids etc) ... function, the textmerge capability, and the old pre-FRX report commands. ... SET DECIMALS, SET FIXED, ?, etc. only apply to the display of a number. ...
    (microsoft.public.fox.programmer.exchange)