Share via

Two variable data table doesn't show negative results

Anonymous
2022-06-29T19:02:41+00:00

I created a two variable data table ( What if analysis) and for some reason, the table doesn't show the negative values when the results are negative, and instead shows zero values. I know that some results in the sensitivity table should be negatives.

Thanks !

Microsoft 365 and Office | Excel | For business | Windows

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 No comments

1 answer

Sort by: Most helpful
  1. HansV 462.6K Reputation points
    2022-06-29T19:31:50+00:00

    Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

    Was this answer helpful?

    0 comments No comments