Formula using Percentages

[Tubbs123]

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

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

<tbody>
</tbody>

The figure in F is what the formula should return.

Thank you in advance

 

[njimack]

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