Round up function

I have total hours worked say 1.30…I would like to round up to 1.50 and not to 2 or 1
the functions Floor, Ceiling, Round rounds to the nearest integer, like to round up to nearest decimal,
Any workaround or expressions which can do it
Else it’s a much-needed feature.
Thanks

What do you expect when it’s i.e. 1.65? Do you want to round it up to 2.00 or down to 1.50?
OR
What do you expect when it’s i.e. 1.05 or 1.15? Do you want to round it up to 1.50 or down to 1.00?
What should be the condition?

1 Like

when its 1.65 to 1.50

ROUND([DECIMAL]*2)/2.0 should do it

4 Likes