+ Reply to Thread
Results 1 to 3 of 3

Using a Dummy Variable

  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.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Using a Dummy Variable

    You could always use a row under the first row

    So row 1 would be 1, 10 , 100 , 1000
    and row 2 would be

    =IF($A$5=1,A1*0.3,A1), =IF($A$5=1,B1*0.3,B1), =IF($A$5=1,C1*0.3,C1), =IF($A$5=1,D1*0.3,D1)

    Where A5 would be your variable cell

  3. #3
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Using a Dummy Variable

    Little different:
    =A1*(1+0.3*A2)

    Where A1 is your base value (1 ,10, 100, etc.) and A2 is your dummy variable.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

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