Share via

Sensitivity Analysis Error - showing the same value

Anonymous
2024-04-25T12:39:21+00:00

Cant seem to figure out why the what-if analysis are showing the same value
This is what in inputted
Row input cell: $C$27
Column input cell: $C$28

I've referenced and included the formula in all the variables used

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-25T14:35:28+00:00

    Hi Vivian S!

    I am Shakiru, an independent advisor and an Excel user like you, and I am glad to be helping you out today.

    Have you checked all the cell references?

    • Ensure that the cell references in your formulas are correct and accurately point to the input cells and variables you intend to use for the What-If Analysis.
    • Double-check the values in the input cells ($C$27 and $C$28) to ensure they contain the correct data. Even a small mistake in these cells could cause unexpected results.
    • If your formulas are referencing other cells or ranges, ensure that those references are correct and up-to-date.

    In addition to the image you shared, please provide information regarding the formula used including the expected result.

    I await your response for further help

    Best Regards, Shakiru

    0 comments