+ Reply to Thread
Results 1 to 1 of 1

Creating data tables - recording outputs for different variable inputs

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    ldn
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating data tables - recording outputs for different variable inputs

    Hey all,

    Spreadsheet has one input for the time being - revenue.

    There are 2 outputs - DBE Profit and Traditional Profit.

    I want excel to record the vales for DBE Profit and Traditional Profit as I change the value for revenue.

    So when I change revenue to X, I want the corresponding values of DBE Profit and Traditional Profit (which are determined by X) to be recorded in a table.

    How would I achieve this?
    Have attached a picture of the spreadhseet for clarification.

    Cheers.

    Solved! Thanks to this YouTube video: http://www.youtube.com/watch?v=kfznvWGzt0Y
    Last edited by Veej; 08-09-2010 at 10:31 AM. Reason: Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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