Donate SIGN UP

Ms Excel

Avatar Image
Zeeshan0959 | 12:41 Thu 03rd Nov 2016 | Jobs & Education
5 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 5 of 5rss 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.
If you have a formula in both columns, then when you input data into a cell in one column it would give the converted figure in the corresponding cell in the other column. Wouldn't that work then whichever cell you entered the data into.
Just to clarify- if you enter say 5 feet into cell A10 (say) the value would overwrite the formula so it would show 5 feet. In cell B10 the calculation would kick in and convert it metres. The same would happen the other way round if you entered the metre value into B11 it would mean the calculation in A11 would kick in
Is Ms Excel any relation to Ms Pacman ?
-- answer removed --

1 to 5 of 5rss feed

Do you know the answer?

Ms Excel

Answer Question >>