MackenziePhilli
5 years agoQrew Trainee
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
------------------------------