FAQ: How do you use the If-Else Statement in Calc? [OpenOffice Calc Decision Making]

Recently I had a client that wanted to automatically calculate rental increases based on the date that the lease expired. He didn't have a large amount of criteria, so I used an If-Else test to evaluate which percentage increase should be applied to the rental amount. We ended up with a spreadsheet that looked like this: This used two functions: IF(Condition;Perform if TRUE; … [Read more...]