#1
|
|||
|
|||
Restricting cookbook fractions to 1/2, 1/3, 1/4 and 1/8
February 17, 2017
As part of a cookbook I’m editing I want to offer buyers an Excel spreadsheet that converts various weights and measures, just as one so often sees elsewhere. My question has to do with converting to fractions. How can I restrict the fraction of a number converted with a fractional part to to halves, thirds, quarters and eighths? Cups, for example, are often expressed as halves (7.5 cups) or quarters (7.25 cups). But they are also expressed as thirds (7 1/3 cups). Indeed, the two liquid cup measures in my kitchen are both delineated into thirds as well as halves and quarters of a cup. I need eighths because small amounts of a critical ingredient such as yeast could get rounded up to 0.25 or, worse, down to 0. How in Excel can I restrict any number’s conversion only into halves, thirds, quarters and eighths? Can this be done? Can Excel be forced into rendering numbers only to the nearest eighth or quarter or third or half (and integers, of course)? I’ve played around with this for a few hours, including a fair amount of online research, and I’m nowhere. The problem is that I’m a moron, so I’m hoping people on this forum who aren't can offer a solution or two. In case it helps, one suggestion that I don't understand and cannot figure out how to implement in Excel but that does seem to work sometimes somehow involves the MOD(ulo) function. Another suggestion uses VBA. Thanks to anyone who understands the problem and has some idea how to solve it. |
#2
|
||||
|
||||
Hi
perhaps have a look at the CEILING function
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
This subject is being discussed extensively here
https://www.mrexcel.com/forum/excel-...1-3-1-2-a.html and here http://boards.straightdope.com/sdmb/...php?p=20002063 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fractions Within Fractions | ALAN_VA | Word | 1 | 12-13-2016 10:00 AM |
Fractions and Text Plurals | ImAhNoBoDy | Excel | 0 | 06-20-2014 08:56 PM |
Restricting paragraph styles without restricting character styles | Red Pill | Word | 5 | 05-25-2012 01:06 PM |
autocorrect for fractions | AusSoft | Word | 3 | 01-24-2010 06:55 PM |
Inserting Fractions | ali_c_uk | Excel | 1 | 11-29-2009 06:38 AM |