what-if-analysis

  1. D

    What-if - Two Variable Data Table showing incorrect values

    Hi Everyone, I have a data table to test the profit at different price points. I seem to be getting incorrect values from a two variable data table. The 1st row of values comes out correct but the rows below it are incorrect. After searching online for a bit, I can’t see to find a way to...
  2. L

    Question: Excel 2016 What-if statement

    I am thinking about applying a what-if analysis to find out the one time cost for a LED bulb but I am not sure if the what-if analysis should have a two variable (separate fixed and variable cost) or a one (only variable cost) and how I formulate such a what-if condition. I am enclosing a...
  3. E

    Sensitivity Analysis

    Hey everyone, I have two difficulties to finalize my Sensitivity Analysis and hope that someone can help me out. This is my simplified basis table: <tbody> Income Statement Forecast NET SALES 4907,7 Number of Stores 368 Net Sales per Store 13,3 Cost...
  4. M

    What-If-Analysis

    [SIZE=2]Hello everyone, First, thanks for reading this and providing help. For the most part, I try to do everything on my own so that I can learn excel, but I have hit a brick-wall. My assignment reads: I believe this is the what-if-analysis, but I can't get it work the way its showing in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top