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 de...
See the attached demo workbook. I added some helper columns to make the steps taken visible.
Excellent!
