Forum Home
PC World Chat
 
Thread ID: 120118 2011-08-25 10:36:00 Excel Goal Seek AJD (16514) PC World Chat
Post ID Timestamp Content User
1226100 2011-08-25 10:36:00 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
AJD (16514)
1226101 2011-08-26 00:13:00 Try excel.tips.net - I haven't used Goal Seek myself, but Allen Wyatt's site has helped me with other issues johcar (6283)
1226102 2011-08-26 00:39:00 Thanks so much - will give it a go :-) AJD (16514)
1