Ceiling function and drag and drop

Hi guys,
I have this formula in which I want to things:
1* In my spreadsheet the first formula, does the upper case function, but if I try to drag and drop in that range, it gives and error in VBA.
2* In the same spreadsheet the second formula, works to turn decimal into duration by round it, but I want to add a round of multiple of 15, thing that I can do in a normal excel sheet using the "=Ceiling(E15,15)".
... SO, I want to apply the Ceiling in this formula, without taking off the round function which is already there.
here is the formula:

Please Login or Register  to view this content.

Originally Posted by Isaacadete

Hi guys,
I have this formula in which I want to things:
1* In my spreadsheet the first formula, does the upper case function, but if I try to drag and drop in that range, it gives and error in VBA.
2* In the same spreadsheet the second formula, works to turn decimal into duration by round it, but I want to add a round of multiple of 15, thing that I can do in a normal excel sheet using the "=Ceiling(E15,15)".
... SO, I want to apply the Ceiling in this formula, without taking off the round function which is already there.
here is the formula:

Please Login or Register  to view this content.

It's so awesome, please explain to me how you done, so the next time I might be able to do it so.