Forum Discussion
Linking Various Formulas
Hi, I would like to link 3 different formulas together, that allows me to edit the number without altering the formulas. For example, I want to link a formula to calculate cm, to feet, to inch and v...
Hi,
Here is a photo of what I am trying to do.
So I want to be able to type in the box cm, feet or inch so that they will change accordingly like an auto calculator. So eg, if I type 1 feet, the inch would change to 12inch, cm to 30.4cm. If I were to type in the inch box, it should change the feet and cm accordingly.(:
Hi
A formula-wise solution you would need some helper cells. Otherwise you have to use a macro.
I offer you the formula solution.
| cm | ft | in | cm | ft | in | ||
| 4 | 4 | ft | 121,92 | 4 | 48 |
D2: =LOOKUP(9^9,A2:C2) or SUM(A2:C2) or MEDIAN() or AVERAGE() ...
E2: =IF(COUNT(A2:C2)=1,LOOKUP(9^9,A2:C2,A$1:C$1),"Type only ONE number")
F2: =CONVERT($D2,$E2,F$1)