Repeated Offset
I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the coefficient of sales prediction based …
0% interest promotion
The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not. This helped me a lot in consolidating my debts …
Limited Ceiling
The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round number to any value up Unlike ROUND, ROUNDUP and ROUNDDOWN, that …