Conversion of Volume or Weight

[Slobey]

Hi,

I am making a solution for recipe conversion. I have a script that will convert the amounts when the number of servings is changed. The basic conversion is easy. Just a multiplying calc. The problem I have is that if a recipe calls for 4 fluid ounces for 4 servings and I convert it to 12 servings I get 12 ounces and I want it to say 1 1/2 cups. I have a script that basically tries to take into account every possible scenario and rounds off as well. I convert everything to milliliters or grams and then converts. But I am thinking there is a simpler way to do this. Any suggestions would be greatly appreciated

Thank you

[Ugo DI LUCA]

Hi,

Create a ConversionsTable.

Then Lookup ( ) or LookupNext ( ) should do it for you straight without any loop needed.