Forum Discussion

Buckeye55's avatar
Buckeye55
Copper Contributor
Jul 19, 2019

Need assistance with an If Then formula

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 direc...
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Jul 19, 2019

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

Buckeye55's avatar
Buckeye55
Copper Contributor
Jul 19, 2019

PReagan 

It kicked back #VALUE

Resources