Formula using Percentages

[Tubbs123]

I have a formula that I want to write as follows:

[TABLE="width: 920"]
<tbody>[TR]
[TD][TABLE="width: 920"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Country[/TD]
[TD]Charge Rate Card[/TD]
[TD] 15% Margin[/TD]
[TD]New %margin[/TD]
[TD]new rate[/TD]
[TD]formula for cells in column F[/TD]
[/TR]
[TR]
[TD]C&W Europe[/TD]
[TD]Austria[/TD]
[TD="align: right"]€ 750.00[/TD]
[TD="align: right"]€ 637.50[/TD]
[TD="align: right"]23.39%[/TD]
[TD="align: right"]€ 637.50[/TD]
[TD]IF E2 is less than 15% then increase D2 by the difference in percentage, otherwise D2[/TD]
[/TR]
[TR]
[TD]C&W Europe[/TD]
[TD]Belgium[/TD]
[TD="align: right"]€ 700.00[/TD]
[TD="align: right"]€ 595.00[/TD]
[TD="align: right"]12.16%[/TD]
[TD="align: right"]€ 611.90[/TD]
[TD]IF E3 is less than 15% then increase D2 by the difference in percentage, otherwise D2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The figure in F is what the formula should return.

Thank you in advance

 

[njimack]

=d2*if(e2<15%,(1+(15%-e2)),1)