Here's the way I would run the formula (first check to make sure that metric checked is correct then find the conversion factor within the array). Another simpler option would be to create a lookup table and use VLOOKUP.
=IF(OR(J8={"cups (US)","fl. oz. (US liquid)","gals. (US liquid)","litres","pints (US liquid)","quarts (US liquid)","Tbs. (US)","tsp. (US)"}),
I8/LOOKUP(J8,{"cups (US)","fl. oz. (US liquid)","gals. (US liquid)","litres","pints (US liquid)","quarts (US liquid)","Tbs. (US)","tsp. (US)"},{0.00422,0.03381,0.00026,0.001,0.00211,0.00105,0.06762,0.20288}),
"Metric is not registered")
abousetta
Bookmarks