I would like to make formulas that allow the user to adjust or enter any of the fields and the others field respond, I.E. any field could be an input or an output.
For example a simple calculation of Fahrenheit to Celsius where each is a field: the user could enter a temperature into Fahrenheit by entering the first field and the second field would update showing Celsius or the user could enter Celsius and the Fahrenheit would update.
This sounds like a loop so I assume a one time run trigger would be needed, hitting the return key for example.
- The topic ‘Enter data into either field: other field responds F->C or C-> F’ is closed to new replies.