I'm trying to create a dynamic supplies cost list to help calculate the costs of our recipes whenever we switch suppliers. The idea is to enter the unit price (say of oil - see screenshot), then use a data validation drop-down list to select the size of the unit, and then have a breakdown of the remaining units automatically calculated based on the selection.
Ex: Canola oil, $17.82 (unit price) at 5 gallons (data validation selection) should automatically have that price broken down in the following columns per lb, per ounce, per kg, per gram, etc.
I've searched for some examples of this already but maybe I'm not using the right search terms because I can't find anything? Any help would be appreciated!