Can you explain a bit and attach some data or packaged workbook. This looks Confusing to me.
I have five variable and I want to make a formula.
the formula is 1-((1-(variable_1)*(1-(variable_2)*(1-(variable_3)*(1-(variable_4)*(1-variable_5))
but, I want to filter some variable and the results changing automatically.
for instance, I filter variable_1 and variable_2 then the results should change
variable.twbx 39.9 KB