Thread: Excel VBA Multiple Automatic Goal Seek Required – Please Assist us
View Single Post
 
Old 06-21-2014, 09:11 AM
champaben champaben is offline Windows 8 Office 2007
Novice
  
Join Date: Jun 2014
Posts: 6
champaben is on a distinguished road
Default
Quote:
Originally Posted by whatsup View Post
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.
Hello,

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.
Reply With Quote