Hello Excel Experts!
I have a question about how to use a What-If Data Tables with an If-Then statement.
I want the what-if data table to have conditional inputs based on the If then condition.
I've tried the following approaches, but they fail:
{={TABLE(A2,IF($D$1="X",A3,A4))}
-or-
=IF($D$1="X",{TABLE(A2,A3)},{TABLE(A2,A4)})
Has anyone done this or have an idea for a solution?
Many thanks
I have a question about how to use a What-If Data Tables with an If-Then statement.
I want the what-if data table to have conditional inputs based on the If then condition.
I've tried the following approaches, but they fail:
{={TABLE(A2,IF($D$1="X",A3,A4))}
-or-
=IF($D$1="X",{TABLE(A2,A3)},{TABLE(A2,A4)})
Has anyone done this or have an idea for a solution?
Many thanks