Donate SIGN UP

Ms Excel

Avatar Image
Zeeshan0959 | 12:45 Thu 03rd Nov 2016 | History
7 Answers
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.
Gravatar

Answers

1 to 7 of 7rss feed

Best Answer

No best answer has yet been selected by Zeeshan0959. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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?
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.
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
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
There is a circular reference warning but you don't have to heed it. I've just set the spreadsheet up and it worked
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.
Use the Convert function if you want a neater formula
=CONVERT(a1,"ft","m")
=CONVERT(b1,"m","ft") etc

1 to 7 of 7rss feed

Do you know the answer?

Ms Excel

Answer Question >>