Creating a formula for a specific problem

Copper Contributor

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

 

3 Replies

@CezanneVDW 

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

@HansVogelaar 

As an alternative If these are the correct results.

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