Multiplying Columns by Different %'s

I am trying to multiply different columns by different %'s and I am stuck. I need to multiply "Current" column by .08%, "1-45" by .35%, "46-100" by 2.55%, "101-175" by 10% and "Over 175" by 46%. I then need to subtotal the amounts by region. So when it is complete, region C will have cell C4 multiplied by .08%, region C cell D4 will be multiplied by .35% and so on. Anyone have a suggestion?

Thanks!

Multiply Different Columns by Different %s.xlsx

Best Practices

Accepted answers

Step 1: Input

Step 2: Removing the unwanted rows below

Step 3:

Step 4: Filtered only the output

Shanker V

All comments

I'm sorry but I don't quite understand what you are trying to do. Please mention how is your raw data and how you want the output to be.

Hope if I understand your requirement correctly, please find the below output which you are expecting.

Many thanks

Shanker V

Step 1: Input

Step 2: Removing the unwanted rows below

Step 3:

Step 4: Filtered only the output

Shanker V

Kindly let me know if this resolves your issue.

If not, please let me know where you are struck.

Shanker V

@ShankerV Thank you for the help!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703