google sheets – Possible to Convert and Display Weight Value in both Kilograms and Pounds and Ounces?

Use three entry columns — pounds, ounces, kilograms — and two formula columns like this:

=ifs( 
  (E2 + F2) * G2, 
    "enter lb+oz, or kg, not both", 
  E2 + F2, 
    sum( convert(E2, "lbm", "ozm"), F2 ), 
  G2, 
    convert(G2, "kg", "ozm"), 
  true, 
    iferror(1/0) 
)
=ifs( 
  (E2 + F2) * G2, 
    "enter lb+oz, or kg, not both", 
  E2 + F2, 
    convert(H2, "ozm", "kg"), 
  G2, 
    G2, 
  true, 
    iferror(1/0) 
)

The formula columns let you see the result in both ounces and kilograms for every entry.

See the new Solution sheet in your sample spreadsheet.