Excel f(x)s = Excel Functions
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).
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 commit to pay in order to keep it actually 0%.
So here is the formula.
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 D2 which is 22 into the next 7 up, 7 is in D3, result is 28 as you can see
