Use “What if analysis data table”


June 6th, 2013 by Joan Kang Joan Kang

i use “What if analysis Data Table” to generate the profit. When i manually key in number in FC (please refer attach excel file), the profit is correct. But when i add in formula in FC, the profit become incorrect. Why?

 

http://www.excel-course.com/wp-content/uploads/2013/06/Sensitivity-analysis-eg.xlsx

2 Responses to “Use “What if analysis data table””

  1. BenneTan BenneTan Says:

    hi there joan. i cannot see any file. would you like to send it to us?
    benne.tan@everydayexcel.com.sg

  2. BenneTan BenneTan Says:

    Hi Joan,

    As mentioned in the email, the Fixed Cost portion will not work because the formula you are using in D4 is based on B9, and E6 is based on B9 (the cell that is supposed to be the variable in What-If Analysis).

    You can either:
    1. Not link the formulas back to the variable like =3000*(1+D5) in E5 or key in 3000 in D4 or;
    2. Use formulas as an alternative:
    =$B$4-$B$8-E5

Leave a Reply

You must be logged in to post a comment.

s2Member®