It works similar to the MROUND function but the only difference is that CEILING always rounds up. Also add the formula B27 in C2 to calculate the duration in weeks. Note that 58 is rounded to 63.
63 is rounded up to 7 and negative numbers with decimal portions are rounded toward zero eg.
As a financial analyst. And we wish to highlight the rows in the given groups of 3 we can use the excel formula ISEVEN CEILING ROW -1933 in conditional formatting and output will be as follows. The CEILING function in Excel can be used to round the prices to the nearest 25 cents multiple too. The function was introduced in MS Excel 2013.