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
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:
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....