Adjusting Percentages with Percentages

[Country_Calc]

More math than excel, but I am trying to reduce the effect of a percentage with another percentage and cannot figure it a solution that works for increases and decreases.

Formula used 1-(A*B*C) works for adjustments (column B) for 1 to 100%, but causes error when adjustment is greater than 100%

A (Main Value)	B (Adjustment + or -)	C (Percentage effect)	D (Desired Result)
1	50%	100%	.5
1	50%	50%	.75
1	150%	100%	1.5
1	150%	50%	1.25

 

[jasonb75]

How did you calculate your desired results?

 

[Country_Calc]

1-(A1*B1*C1) = desired results

This does not work for increases (150%)

 

[jasonb75]

OK, let me be more specific, how did you calculate the 'correct' desired results for the last 2 rows?

 

[mikerickson]

How about
=A1*( 1-(1-B1)*C1 )

It looks like your logic is that C is applied not to B, but to the change resulting from B. Multiply C1, not by B1, but by (1-B1) and then change A1 by that amount.

 

[Country_Calc]

Yes, =A1*( 1-(1-B1)*C1 ) works perfectly thanks so much. I need to take some remedial algebra