+ Reply to Thread
Results 1 to 3 of 3

Making two formulae cells equal each other (have 3 variables that can change)

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    2

    Making two formulae cells equal each other (have 3 variables that can change)

    Hi there,

    I'm currently writing my thesis on changes in tax policy and I am looking for a way to make two cells equal each other. All the formulae are based on 3 cells: Taxable income, medical aid contributions and additional medical expenses. These are the only cells which you can change the value of and the rest of my formulae change with them. I want to find what combinations of values for these cells make my final tax payable cells equal. I know this could be hundred of combinations but that's what I need!

    I don't know much about macros or VBA at all. All I know is that in excel this is most likely where the answer lies!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Making two formulae cells equal each other (have 3 variables that can change)

    Can you use scenarios?

    http://www.homeandlearn.co.uk/excel2...l2007s7p3.html
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    09-05-2014
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2013
    Posts
    2

    Re: Making two formulae cells equal each other (have 3 variables that can change)

    I can use anything that will give me an answer of making those 2 cells equal! I am terrible at excel tho. And I know there should be a minimum of 4 combinations but probably more than that...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Making multiple cells equal to other cells
    By forrestcupp in forum Excel General
    Replies: 5
    Last Post: 12-31-2013, 03:19 PM
  2. [SOLVED] Making a drop down menu that will change formulae
    By codyryan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-10-2013, 04:42 PM
  3. Compare two cells and if they are not equal change colour
    By up_and_under in forum Excel General
    Replies: 2
    Last Post: 05-26-2011, 10:02 PM
  4. making copied cells change with change in original cell
    By Jennifer Mcdermeit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 11:58 AM
  5. [SOLVED] making cells change relative to each other?
    By MMA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-13-2006, 12:25 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