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

S

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!

:eek:D
 
S

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,

:eek:D
 
R

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,

:eek: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"
 
D

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. :eek:D
 
R

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. :eek:D

Glad to help. Thanks for the feedback.
 
D

David Biddulph

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

David Biddulph

"DianaG" wrote in message
....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top