Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
I am making a spread sheet, and want to give the user the option to input data in inches, millimeters or both (mixed). I have an inch and a mm column and want both filled out when data is entered in either one. So if I put an inch value in an inch cell (A1), I want the adjacent mm cell (A2) to convert to mm which is easy (=A1*25.4), but I tried to put =A2/25.4 in A1 and got an error message. How do I make it work in both directions?
The whole idea is to let a machinists enter measurements from parts plans that have different units of measure without having to convert them first, and giving them the option to use whichever their equipment allows.