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

Occasional Visitor

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?

0 Replies