AJD

25-08-2011, 09:13 PM

Hi

I am currently undertaking some study and am struggling with the concept of Goal Seek.

I have a total of about $145,000 in cell D50, and I want to change a markup rate which I have in B6 (not a formula) so that the D50 cell contains $1.00.

I have tried to use the goal seek in Excel (2010) but I seem to get a hideous number of negative thousands and the amount in D50 remains the same i.e does not change to $1.00.

I am relatively new to this concept so any advice offered would be greatly appreciated.

Thanks

I am currently undertaking some study and am struggling with the concept of Goal Seek.

I have a total of about $145,000 in cell D50, and I want to change a markup rate which I have in B6 (not a formula) so that the D50 cell contains $1.00.

I have tried to use the goal seek in Excel (2010) but I seem to get a hideous number of negative thousands and the amount in D50 remains the same i.e does not change to $1.00.

I am relatively new to this concept so any advice offered would be greatly appreciated.

Thanks