News11 mins ago
Ms Excel
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.
Answers
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.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
-- answer removed --