+ Reply to Thread
Results 1 to 4 of 4

Need help creating a formula/sheet with a fixed variable

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Reidsville, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need help creating a formula/sheet with a fixed variable

    This is what I currently have in the fields that really matter to what I need...

    C4 = (This is to be my variable field. Here I would either enter a 1, 2, or 3 to note which formula to ultimately use - see below)
    D4 = Is an entered amount
    E4 = Is the actual formula which currently looks like this
    =D4*0.003

    This will go from line 4 down through as many line as I need, so it could be C50,D50 and E50.

    Ultimately field E2 will total all the amounts in the the E column, which is the number I need from this worksheet, it's formula is:
    =SUM(E4:E50)

    Pretty simple.

    What I currently have to do is go in and manually adjust in the E field of any given row that is not the default *0.003

    What I'd like to happen is this
    When I enter a "1" in the C4 field then my equation in E4 needs to be ...*0.003
    When I enter a "2" in the C4 field then my equation in E4 needs to be ...*0.005
    and when I enter a "3" in the C4 field then my equation in E4 needs to be ...*0.009

    Of course this needs to carry down to each line as I go..C5,D5,E5; C6,D6,E6....

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Need help creating a formula/sheet with a fixed variable

    Hi Reman,
    When I enter a "1" in the C4 field then my equation in E4 needs to be ...*0.003
    When I enter a "2" in the C4 field then my equation in E4 needs to be ...*0.005
    and when I enter a "3" in the C4 field then my equation in E4 needs to be ...*0.009
    and this E4 should fetch those results using some formula (i.e.=D4*0.003) or what ?


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Need help creating a formula/sheet with a fixed variable

    in E4
    =D4*LOOKUP(C4,{1,2,3},{.003,.005,.009})
    and copy down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    05-13-2013
    Location
    Reidsville, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need help creating a formula/sheet with a fixed variable

    Thank you Special-K, that's what I needed!

    Bill

+ 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