Help adding in a % deduction to an existing formula.

[Oryan77]

Hello, I have the following formula on a sheet being used in cell F7:

=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!

 

[bobsan42]

=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))

 

[Oryan77]

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

=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]

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