Forum Discussion
Creating a formula for a specific problem
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
See the attached demo workbook. I added some helper columns to make the steps taken visible.
Excellent!
