+ Reply to Thread
Results 1 to 3 of 3

Need to use redundant/multiple funtions

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    Chicago, IL
    MS-Off Ver
    Office 365
    Posts
    1

    Need to use redundant/multiple funtions

    I am working through my company's annual salary review process. I would like to be able to make changes to any of the columns and it affect the others. Basically, I want to be able to change the % and it adjust the increase amount and new salary. Or if I change the increase amount that it change the percentage and total, and if I change the new salary, it factors the increase and percentage.

    EDIT: I should also add that there is a column for current salary.

    fh.JPG
    Last edited by rebeccasievert; 08-05-2019 at 09:34 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,743

    Re: Need to use redundant/multiple funtions

    What you ask is not functionally available in Excel. A cell can only contain a value (that which you enter) or a formula (a calculation based upon input to another cell). You cannot have it both ways. It is an either/or situation.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,207

    Re: Need to use redundant/multiple funtions

    Agree with Allan.

    A work-around to this would be to have those "variable" cells on their own, then, depending on what is entered and what is left blank, a 2nd set of cells would then run the required calcs for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Multiple IF Funtions within one formula
    By chrystal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2014, 11:25 PM
  2. [SOLVED] Collapse multiple rows of data for a common item and delete redundant data
    By moniqueammi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2014, 12:41 PM
  3. Replies: 2
    Last Post: 08-02-2013, 10:41 PM
  4. Help with multiple IF funtions
    By asw301 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2012, 05:55 AM
  5. Linking multiple IF funtions.
    By snapfish412 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2012, 02:12 PM
  6. Add Quantity of Redundant Rows, then Delete Redundant Rows
    By alexwgordon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2012, 12:12 AM
  7. Using the IF funtions to evaulate multiple cells
    By deananne in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-06-2011, 05:21 PM

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