Multiple if statement for a column

Hello.

I have a table with 3 columns.  I would like the 3rd column to have all the values in KG (converted to KG).  How do you query or create a column to accomodate all the if statements?  Thanks.