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.



rent = 7000, sewerage = 650

rent + sewerage = 7650


3 Replies


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

@Hans Vogelaar 

As an alternative If these are the correct results.