Results 1 to 9 of 9

Converting food measurements from US UK to Metric (Aus)

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Melnbourne Australia
    MS-Off Ver
    365
    Posts
    2

    Converting food measurements from US UK to Metric (Aus)

    Hi, I am writing a scaling recipe workbook that converts US UK measures to metrics (Aus). The formula to convert the measures works.

    IF($J11="Eggs",$AA11/12,($AA11*XLOOKUP($H11,rngRecipeMeasure,Conversion_Factor,$H11,0))) ` this works

    But I also want to convert "each" eggs to dozen if there are more than 12 eggs

    can I combine the 2 formulae and if there is another measure bring that up or another "each" and leave it as each.

    I am stuck
    Happy to upload the file I am not precious about the file it is there to be used

    Zaida
    I have uploaded the file and thanks for the excel version error I am using 365
    Attached Files Attached Files
    Last edited by Zaida; 04-21-2022 at 05:53 AM. Reason: uploading the file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-23-2019, 03:14 AM
  2. need help building a food web.
    By Sezra in forum Excel General
    Replies: 3
    Last Post: 10-17-2014, 01:30 PM
  3. Help with food question
    By richardwedamins in forum Excel General
    Replies: 1
    Last Post: 05-16-2012, 06:05 PM
  4. Converting metric to imperial measurements
    By mdoyle13 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2012, 03:58 AM
  5. function to change metric measurements
    By devo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2006, 06:10 AM
  6. [SOLVED] What is the Formula to Convert Imperial to Metric Measurements
    By compu_trainer in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 03:05 AM
  7. Metric to imperial measurements
    By Gill.star in forum Excel General
    Replies: 7
    Last Post: 03-06-2005, 10:06 PM

Tags for this Thread

Bookmarks

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