Ms Excel

[Zeeshan0959]

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.

[mccfluff]

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?

[TheChair]

You can't do it with only columns, as each column would require a conversion formula which would be overwritten if you typed a value into it.

[Calibax]

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

[barmy]

If entering in feet column cell A1, formula in metre column cell B1 =A1*0.3048

If entering in metre column cell A2, formula in feet column A1 =A2/0.3048

There are fancy ways for it to be automated if a figure is entered into each cell using macros but this isn't the right forum

[fiction-factory]

There is a circular reference warning but you don't have to heed it. I've just set the spreadsheet up and it worked

[Old_Geezer]

Only because you overwrite one or other of the formulas.
But it isn't difficult to arrange these conversions on different rows or different columns.

[ichkeria]

Use the Convert function if you want a neater formula
=CONVERT(a1,"ft","m")
=CONVERT(b1,"m","ft") etc