Results 1 to 7 of 7

New to excel, having trouble changing values based on an input cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2006
    Posts
    7

    New to excel, having trouble changing values based on an input cell

    I'll try to keep this example small so it's easier to understand.

    The spreadsheet has 2 "tables" (not really tables, but they are in their own area if you know what I mean).

    Table #1: (output)
    Cell A's value: 2
    Cell B's value: 3

    Table #2: (input)
    Cell A's value: 1.00

    Basically what I want to do is, when I change the 1.00 value in table 2, I want both cell A and cell B in the first table to update to the amount specified in table 2 as a decreased percent value.

    So, if I typed 0.95 into table 2, the results should be:

    Table #1: (output)
    Cell A's value: 1.9
    Cell B's value: 2.85

    The other piece of the question is, how can I revert the first table's values back to their "saved" state if I change table 2's value back to 1.00? As in, cell A would change back to 2 and cell B would be 3, if I entered 1.00 into the second table's cell.

    Thanks. Also keep in mind, I am a newbie to excel. The spreadsheet I'm working on now has about 150 different cells that need to be updated based on 1 value, so if there's an easy way to drag/drop the cells I want modified into a function, please share.
    Last edited by MyUserName; 09-14-2006 at 02:39 PM.

Thread Information

Users Browsing this Thread

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

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