Forum Discussion

MackenziePhilli's avatar
MackenziePhilli
Qrew Trainee
5 years ago

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
------------------------------
​​​