I have two columns named meters and feet in ms excel. i can put input in either feet column or in meters column. i want excel to convert feet into meters if i give input in feet column and convert meters into feet if give input in meters column.
you just nee to put the appropriate formula into each column to tell it to do that - or is that what you are asking, you want to know the formula to use?
I don't think you can do it that way or you will have a circular
reference. I think you need 4 columns: input feet/output metres/
input metres/output feet