Results 1 to 26 of 26

Goal seek for two cells

Threaded View

YasserKhalil Goal seek for two cells 05-22-2016, 12:12 AM
MrShorty Re: Goal seek for two cells 05-22-2016, 12:23 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 12:45 AM
MrShorty Re: Goal seek for two cells 05-22-2016, 01:02 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 01:13 AM
MrShorty Re: Goal seek for two cells 05-22-2016, 01:21 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 01:33 AM
MrShorty Re: Goal seek for two cells 05-22-2016, 01:42 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 01:48 AM
MrShorty Re: Goal seek for two cells 05-22-2016, 02:01 AM
Crooza Re: Goal seek for two cells 05-22-2016, 02:07 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 02:55 AM
Crooza Re: Goal seek for two cells 05-22-2016, 03:35 AM
Crooza Re: Goal seek for two cells 05-22-2016, 04:51 AM
YasserKhalil Re: Goal seek for two cells 05-22-2016, 05:50 AM
YasserKhalil Re: Goal seek for two cells 05-23-2016, 03:55 AM
Crooza Re: Goal seek for two cells 05-23-2016, 04:11 AM
YasserKhalil Re: Goal seek for two cells 05-23-2016, 05:30 AM
MrShorty Re: Goal seek for two cells 05-23-2016, 11:50 AM
Crooza Re: Goal seek for two cells 05-23-2016, 06:21 PM
YasserKhalil Re: Goal seek for two cells 05-23-2016, 06:44 PM
Crooza Re: Goal seek for two cells 05-23-2016, 06:49 PM
YasserKhalil Re: Goal seek for two cells 05-23-2016, 06:53 PM
Crooza Re: Goal seek for two cells 05-23-2016, 06:58 PM
YasserKhalil Re: Goal seek for two cells 05-23-2016, 07:15 PM
Crooza Re: Goal seek for two cells 05-23-2016, 07:17 PM
  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Goal seek for two cells

    Hello everyone
    I have two constants in B10 and C10 ( 185 and 21.6)

    In the cells (D10 & E10 & F10) I need to solve discover the values (these are unknown values)

    D10 & E10 & F10 would be of total 185
    At the same time I need to sum (D10 * 5% ,E10 * 10% , F10 * 25%) to get the total 21.6

    So I have two goal seeks (yellow cells)

    I can deal with just one goal seek not two
    Sub Goal_Seek_Tax()
        With Worksheets("Sheet1")
            .Range("G10").GoalSeek Goal:=.Range("C10").Value, ChangingCell:=.Range("H10")
        End With
    End Sub
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Goal seek on multiple cells
    By oakwood in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 07:04 AM
  2. Goal seek multiple cells
    By ?? in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  3. Goal Seek on Multiple Cells
    By newtoloop in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1