A samplified problem is described as following:
Let Cell A1 has a value of either "Input" or "Output"
If Cell A1.value = Input Then
Cell B1 will allows the user to input data into it, this data will be use as part of the input of a formula for other cell.
If Cell A1.value = Output Then
Cell B1.value will be the result of the formula from Cell C1, B1 will also be locked so the user could not change it.
Please help, Many Thanks