Results 1 to 3 of 3

Using a Dummy Variable

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Using a Dummy Variable

    Hello, I have a dummy variable cell that is either 1 or 0

    I have another row of values. How can I incorporate this dummy variable cell in the function of this row of values such that their values are increased by 30% when the dummy cell is 1, or stay as is if the dummy cell is 0.

    i.e

    1. row is 1 , 10, 100, 1000.
    2. change dummy variable cell to 1
    3. row becomes 1.3, 13, 130, 1300 etc

    I hope the above makes sense. I want to do this without using any advance tools.

    Any help much appreciated in advance! This is for an assignment that is due shortly!
    Last edited by chadnchady; 10-01-2012 at 09:04 AM.

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