alacrity59
Member
I'm using a data table to do a sensitivity analysis on the effect of two variables on Net Income. The variables are gross margin % and top line revenue. For some reason when the admin expense is a percentage of revenue the data table fails to consider the expense in the results. I don't know if this is new with Excel 2013 . . . but I don't recall ever running into this problems before. I'm uploading a file showing a very simple example of the problem.