Link to home
Start Free TrialLog in
Avatar of jxm90
jxm90

asked on

WhatIf Analysis Data table

Using the excel sheet I need to do a whatif analysis datatable, my teacher says in his directions it will be a whatif data table. I've attached my current excel sheet and an image of what numbers are suppose to be generated.  Can someone please provide a step by step on how this would be achieved using the the whatif analysis button under the DATA tab, my teacher is not very good at explaining it.
case6.xlsx
Untitled.png
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Kardi Teknomo did a nice piece on this.  Check out the link and follow up in this thread if you get stuck on a particular area.
Avatar of jxm90
jxm90

ASKER

Perhaps it cant be done with a data table because i lack the two variables ?
You can also do 1 variable.  That should be on the site as well.
Your class mate posted the same question yesterday and gave me 500 points for the answer. Take a look:
https://www.experts-exchange.com/questions/27930119/Whatif-Analysis-Accounting-Required-Break-Even-Point-Data-Table.html
Let me know if you need more help.
Avatar of jxm90

ASKER

that was me. This is a different question.
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial