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 on the month number, we do have coefficient saved in another table that repeated every year (12 months).

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 (credit card as well others) into interest-free payments. Benefiting from banks and cards promotions. The key part is to determine how much monthly I will […]

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 are limited to number of decimal places. CEILING can round to any number, decimal or not. Below is an example of rounding the number in […]