# Need help creating a formula/sheet with a fixed variable

1. ## 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....  Register To Reply

2. ## 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>  Register To Reply

3. ## 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  Register To Reply

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

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

Bill  Register To Reply

##### Users Browsing this Thread

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

#### 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