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

It would probably help if you uploaded that file, and be sure to show some examples of expected outcomes

I saw you use XLOOKUP function , but your profile say you use Excel 2016.
Please update your profile if needed.

Regards.

Not clear what is expected.

suggestion (not a solution) based on my experience in recipe cost control and analysis (including volume-to-weight analysis of about 3500 ingredients)

you can not have a volume (eg. tablespoon) convert universally to a weight (eg. gm)... it is an impossibility because different foods have different densities.

hint: a tonne of feathers weighs the same as a tonne of lead... but they do not occupy the same space.

the only way to do this is to test foods repeatedly to get an average, and then have different weights by volume for each ingredient.

EDIT:

by the way, an Australian teaspoon is 5ml, and a Australian Tablespoon is 20 ml.

it will be more clear and eazy for you , if you build conversion unit table then use Index/Match to select conversion factor to multiply with original value.

(No need to convert all , for sample no need to convert KG to Liters)

Regards.

the dilemma is how do I create a recipe conversion with all these parameters?

as you are in Melbourne, you might want to take a look at the free "Resort Recipe" software from Resort Software (a Brisbane based company): https://www.resortsoftware.com/products/default.aspx

personally i have never used their free version, i only have experience with their flagship product (Resort Executive), but their free version might help you to envisage how to structure your spreadsheet.