Weight in BOM for metric assembly with some english parts

I have a column in my BOM for Weight. The equation for thecolumn is 'QTY'*'Weight'. I have a metric assembly and add inchparts to it. I make a drawing of the assembly and when I add my BOMthe inch parts show up as pounds. Is there an IF function I couldadd to my equation that could determine which part are in pounds atthe part level and divide the weight by 2.2 to list them as kg?

Thank you,

Karen Ansell
using SolidWorks 2007 sp5.0SolidworksBill Of Materials