Getting cups answer into cups _and_ 1/4 cups increments?

[StargateFan]

A formula in my spreadsheet of =B2/8 returns a value that means cups
(converting ounces into cups).

No matter what the starting figure, though, I only get multiples of 1
cup rather than it breaking down into correct ounces conversion of 9
1/4 cups, 9 1/2 cups, 9 3/4 cups.

I don't need to break it down into cups and ounces but multiples of
cups and quarter cups as shown above. (Does that make sense?) But I
don't know how to do this special rounding type of function.

How can I get this type of output, pls?

Thanks so much!

D

 

[StargateFan]

Oh, I didn't mention that I'm getting the output I am because I need
to have cell formatted with custom: #" cups"

I get partials if formatted as a decimal with two places but it's
easier dealing with measurments to deal with fractions rather than
decimals, anyway. Sorry for forgetting to mention that.

Cheers,

D

 

[Ron Rosenfeld]

Oh, I didn't mention that I'm getting the output I am because I need
to have cell formatted with custom: #" cups"

I get partials if formatted as a decimal with two places but it's
easier dealing with measurments to deal with fractions rather than
decimals, anyway. Sorry for forgetting to mention that.

Cheers,

D

If you "need to have cell formatted with custom: #" cups" "

then you will always see your result in terms of whole cups.

If you want to see cups and fractions of cups, rounded to the nearest
quarter, use one of these formulas:

=ROUND(B2/8*4,0)/4

=MROUND(B2/8,1/4)

Then custom format your cell as # #/# "cups"

 

[DianaG]

If you "need to have cell formatted with custom: #" cups" "

then you will always see your result in terms of whole cups.

If you want to see cups and fractions of cups, rounded to the nearest
quarter, use one of these formulas:

=ROUND(B2/8*4,0)/4

=MROUND(B2/8,1/4)

Then custom format your cell as # #/# "cups"

Thanks, I tried the round formula above (don't know difference between
round and mround) and used the new formatting for the fraction output
and it seems to work just great.

Thanks. I learned a new formatting tip today re the fractions. Going
into my tips folder! <g>

Cheers and thanks. D

 

[Ron Rosenfeld]

Thanks, I tried the round formula above (don't know difference between
round and mround) and used the new formatting for the fraction output
and it seems to work just great.

Check HELP for the difference between the two functions. MROUND
requires either installation of the Analysis Tool Pack, or a version
of Excel 2007 or later.

Thanks. I learned a new formatting tip today re the fractions. Going
into my tips folder! <g>

Cheers and thanks. D

Glad to help. Thanks for the feedback.

 

[David Biddulph]

If you don't know the difference between ROUND and MROUND, Excel help will
tell you.

David Biddulph

"DianaG" wrote in message
....