Multiplying Columns by Different %'s

[BrandonS4]

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!

[gabrielvilella]

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. 

[ShankerV]

Hi @BrandonS4 

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

Many thanks

Shanker V

[ShankerV · Accepted solution]

@BrandonS4 

Step 1: Input

Step 2: Removing the unwanted rows below 

Step 3:

Step 4: Filtered only the output

Shanker V

[ShankerV]

@BrandonS4 

Kindly let me know if this resolves your issue.

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

Shanker V

[BrandonS4]

@ShankerV Thank you for the help!