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.
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)
