Always round result UP
Hello, I have the following formula below that works If([Labor to Date Through]<[Billing Start], Round(ToWeeks([Billing End]-[Billing Start]),1),If([Billing End]<=[Labor to Date Through],0,Round(ToWeeks([Billing End]-[Labor to Date Through]),1))) However, the results in the Round() parts need to always be rounded up to the nearest integer. Is this possible? Thanks. #rounding #formulas ------------------------------ Mackenzie Phillips ------------------------------