# Help adding in a % deduction to an existing formula.

#### Oryan77

##### Board Regular
Hello, I have the following formula on a sheet being used in cell F7:
Code:
``=IF(D7="","",ROUNDDOWN(((T46*K7)+(U46*K9)+(V46*K11)+(W46*K13)+(X46*K15)+(Y46*K17)+(Z46*K19)+(AA46*K21)+(AB46*K23)+(AC46*K25))/D31,0))``
I would like to add the ability in that code to type in a percentage value in cell H7 and have it adjust the total value listed in cell F7 by that percentage amount.

For example:
If cell F7 shows a result of 1800, and cell H7 is given a value of 50%, then F7 will change to 900. Thank you!

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### bobsan42

##### Well-known Member
Code:
``=if(d7="","",rounddown(((t46*k7)+(u46*k9)+(v46*k11)+(w46*k13)+(x46*k15)+(y46*k17)+(z46*k19)+(aa46*k21)+(ab46*k23)+(ac46*k25))/d31,0)*(1-h7))``

Last edited:

#### Oryan77

##### Board Regular
I'm not actually getting a correct result with that formula.

For example, if the resulting value of cell F7 is originally 75 (rounded down), then the formula converts it to -7425 when H7 is 100%.

I'm looking to get cell F7 with a value of 75 (rounded down) to display as 75 when cell H7 is 100%, or 37 (rounded down) if cell H7 is 50%.

#### bobsan42

##### Well-known Member
Well, sort out your math and logic and be as clear as possible whet you ask questions.
50% is never a good example when you try to explain what you need.
And from what you say I now understand that H7 is not a percentage, but is simply a number.
so the formula that will work for you must be:
Code:
``=if(d7="","",rounddown(((t46*k7)+(u46*k9)+(v46*k11)+(w46*k13)+(x46*k15)+(y46*k17)+(z46*k19)+(aa46*k21)+(ab46*k23)+(ac46*k25))/d31*(h7/100),0))``

#### Oryan77

##### Board Regular
I was trying to be as clear as possible. I'm glad my second explanation made more sense. That formula works perfectly, thank you.

Replies
48
Views
696
Replies
3
Views
57
Replies
3
Views
82
Replies
2
Views
237
Replies
7
Views
343

1,195,700
Messages
6,011,193
Members
441,594
Latest member
AVO

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back