+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : How to automatically display "best measurement"

  1. #1
    Registered User
    Join Date
    Kelowna, BC, Canada
    MS-Off Ver
    Excel 2007

    How to automatically display "best measurement"

    First, what I am doing:
    The usage is on a chemical calculation sheet, in which several factors are calculated. The result is along the lines of "add 1,400 grams (4 1/4 cups)". The grams are for logs, the cups as easy common measurements (especially as each chemical weighs differently).

    I am looking for several things here, however:
    I would like the common measurement to display either tsp, tbsp, or cups, down to fractions of 1/8. Preferably, the fractions would be reduced (ie. 1/2 instead of 4/8). Displaying 3rds along with the 8ths would also be okay, as the scoops do include 1/3 cup, but I don't want anything odd like 3/5 or 1/9. I also don't need mixed measurements (ie. "7 cups and 4 tbsp").

    Can anyone give me some pointers on how to go about this? Is it possible to do all this with just a long IF formula? I could do the measurement selection easily enough (tsp/tbsp/cups) based on amount, but I'm not sure how to go about restricting and reducing the fraction display.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast

    Re: How to automatically display "best measurement"

    Hello hjanfield,

    do you really think someone can solve this without seeing a sample file of your data structure and some sample data? A lot of people here are good at Excel, some very good, but none of us are mind readers.

    Post a sample file and mock up your expected results. Explain the rules that lead to the result, e.g. how many tsp, tbsp, cups, whatever, are in a widget.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1