Forum Discussion

SC10FL's avatar
SC10FL
Copper Contributor
May 17, 2019

Multiple Variable WhatIf Data Table where the output is a cell reference

Hello Everyone

 

I was hoping you could help me, I have an output cell that is made from around ten different variables- but I want to look at a whatif table where I look at only two of the variables change, 1,2,3,4,5 on the x axis, 1,2,3,4,5 on the y axis. I have tried having by data table just look at the output cell reference but I get a DIV0# error, is there a way I can get excel to make a table of results just for changing these two variables?

No RepliesBe the first to reply

Resources