Hello,
I have a construction equipment management sheet and I am trying to create a customized rounding formula for the "months rented" cell. Equipment rentals usually charge at intervals of 1-week, after that at 2-week, then after that at 1-month. Because of this, having a value like "1.3 or 1.6 months rented" doesn't make any sense, because they will charge based on 0.25, 0.50, or 1.0 months.
What I want my formula to do is look at the cell and round up to the nearest HIGHER interval, so if cell A said "32.1", cell B would change it to "32.25," or if it said "14.3", cell B would be "14.5" or if it said "4.6" cell B would say "5".
My idea was this:
=IF(RIGHT([Months - Not Rounded]1, 1) >= 5, [Months - Not Rounded]1 + 1 - RIGHT([Months - Not Rounded]1, 1), OTHER NESTED FUNCTIONS)
However, this formula doesn't work once the bold part is inserted, and obviously the other functions need be inserted.
