![]() |
|
|
|
#1
|
|||
|
|||
|
You're right by one thing: Yes, I did miss the reference in E2 to G2
But using my piece of paper a second time it says: G2 = 1/((1/1.2-0.15-M2)/(B2+C2+D2)) Now the question remains if I got it wrong at some point. I don't think so, but it always makes me suspicious if somebody else says "it can't be done" assuming he/she tried on his/her own, and therefore knows what he/she is talking about. So please just check if the formula is doing allright, otherwise you probably will have to do with GoalSeek. |
|
#2
|
|||
|
|||
|
Quote:
Thanks for your response. That does not bring up the right answer on all cells, hence I cannot use that. I have found another method. Thanks anyway. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
automatic entering of multiple words
|
cliff@tauruscommercial.ca | Word | 5 | 06-03-2014 06:06 PM |
| set daily goal for actual workdays, excluding weekends holidays and days off | Brian Reilly | Excel | 1 | 01-24-2014 11:56 PM |
| Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |
Adding a goal line to a chart
|
uhlersa | Excel | 1 | 01-16-2012 08:18 PM |
| Normal.dot Help? Fatally Corrupted; No Fix. Please Assist. | atm0073 | Word | 2 | 09-21-2009 04:02 AM |