Help adding in a % deduction to an existing formula.

Oryan77

Board Regular
Joined
May 9, 2009
Messages
176
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

Links? Where??
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.
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:
Upvote 0
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%.
 
Upvote 0
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))
 
Upvote 0
I was trying to be as clear as possible. I'm glad my second explanation made more sense. That formula works perfectly, thank you.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

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?

Disable AdBlock

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
Back
Top