I have an array with multiple columns of progressively dependent values, ie, ColC depends on ColB depends on ColA. Outside the array there is one input value and one output value.
I want to make a column of proposed input values, and in the next column get back all of the corresponding outputs. How do I do this without combining all the formulas into one cell? (I don't want to do that because it's tedious and easy to make mistakes).
I can't use the IF function because it's boolean, so what can I use to tell excel to sub a particular cell's value for a different cell? Like, when speaking I could say "if x is true, what is y?" to propose a possible reality, but on the computer you can only ask "is x true at this moment?"