compute one of two missing value?

[james]

I want to create a table like this:

column A is the name of the person
column B is height in feet
column C is height in meters

How do I set it up so that if I enter a number in the feet column, excel
would calculate and fill in the meter column, and if I fill in the meter
column, excel would calculate and fill in the feet column?

 

[Don Guillett]

use a worksheet_change event
if target.column=2 then target.offset(,1)=target*_____
if target.column=3 then target.offset(,-1)=target/_____