Jul 19 2019 11:55 AM
I want the following to occur. When I pick say 22 inches from a drop down I want to display that result in the cell with the drop down but then display the conversion to centimeters in the cell directly below the cell displaying 22 inches. The drop downs are already created for inches and centimeters
Jul 19 2019 12:13 PM
Hello @Buckeye55,
Let's say your drop-down is located in cell A1, then in cell A2 put the following:
=CONVERT(A1,"in","cm")
Hope this helps!
PReagan