| 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 | |||||