Creating a formula for a specific problem

[CezanneVDW]

I need to create a formula to work out the following problem:

Current "rent" amount PLUS "sewerage" charge = "amount"

If "amount" is greater than 6% increase of "rent" then "rent" needs to be deducted with the difference thereof.

ex.

rent = 7000, sewerage = 650

rent + sewerage = 7650

[#2]

@CezanneVDW 

See the attached demo workbook. I added some helper columns to make the steps taken visible.

[#3]

@Hans Vogelaar 

As an alternative If these are the correct results.

=A2+MIN(A2*6%,B2)

[#4]

@Detlef Lewin 

Excellent!