M
Michael_JM86
Member
Hi ActEd,
I am playing around with the Examiner's Model Solution Spreadsheet. When re-attempting the goal seek calculation (using the cell references the examiners provide in the Target Pricing worksheet) I am getting a negative solution... :/
Goal seek seems to give multiple solutions, and no matter how many times I re-run it I am not getting the answer of 2.3562 that the examiners give, even though I am using their spreadsheet and their exact goal seek parameters.
Please could you help me identify what I am doing wrong/ not doing...??
Many thanks,
Michael
I am playing around with the Examiner's Model Solution Spreadsheet. When re-attempting the goal seek calculation (using the cell references the examiners provide in the Target Pricing worksheet) I am getting a negative solution... :/
Goal seek seems to give multiple solutions, and no matter how many times I re-run it I am not getting the answer of 2.3562 that the examiners give, even though I am using their spreadsheet and their exact goal seek parameters.
Please could you help me identify what I am doing wrong/ not doing...??
Many thanks,
Michael