Convert Grams to Ounces, Ounces to Grams without a conflict
I would use multiple columns.
The first would be for the Qty -- no units here.
The second would be the units (g or o, or Grams or Ounces, or whatever you
want).
The third would translate/copy to grams.
The fourth would translate/copy to ounces.
Qty Unit Grams Ounces
3 g 3
10 o 0.352739619
The formula in C2: =IF(B2="g",A2,A2/0.0352739619)
The formula in D2: =IF(B2="o",A2,A2*0.0352739619)
Quin wrote:
I am creating my own food log in Excel. When I look up different foods some
are listed in grams, others in ounces. With two columns, one with a heading
of €śOunces€ť and another with a heading of €śGrams€ť I would like to be able to
list one and calculate the other. Both columns can not have formulas that
relate to each other, so I am wondering if there is a neat way to accomplish
this.
1 gram = 0.0352739619 ounces
Quin
--
Dave Peterson
|