Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-582452%22%20slang%3D%22en-US%22%3EMultiple%20Variable%20WhatIf%20Data%20Table%20where%20the%20output%20is%20a%20cell%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-582452%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20hoping%20you%20could%20help%20me%2C%20I%20have%20an%20output%20cell%20that%20is%20made%20from%20around%20ten%20different%20variables-%20but%20I%20want%20to%20look%20at%20a%20whatif%20table%20where%20I%20look%20at%20only%20two%20of%20the%20variables%20change%2C%201%2C2%2C3%2C4%2C5%20on%20the%20x%20axis%2C%201%2C2%2C3%2C4%2C5%20on%20the%20y%20axis.%20I%20have%20tried%20having%20by%20data%20table%20just%20look%20at%20the%20output%20cell%20reference%20but%20I%20get%20a%20DIV0%23%20error%2C%20is%20there%20a%20way%20I%20can%20get%20excel%20to%20make%20a%20table%20of%20results%20just%20for%20changing%20these%20two%20variables%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-582452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
SC10FL
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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies