Round Up (1 Viewer)

[rothjm]

I have a report with costs that I want to round up to the nearest .25.
I have tried the round function but it will only round to the nearest .25 (rounds down if closer, I don't want that).

This will round to the nearest quarter but not always round up.

=0.25*Round([num]/0.25,0)

I have searched and didn't find an answer.
I would greatly appreciate any advice. Thanks

 

[Malcy]

Hi Jeff
This will round up to the nearest half

(Int([MyField]*-2))/-2

so I guess, and you had best try it since I might be talking cobblers, the following would round up to the nearest quarter

(Int([MyField]*-4))/-4

At least it might be worth trying but the more I look at it the more I am suspicious it won't work. Might spark a thought for you though
Best wishes

 

[rothjm]

Hi Jeff
This will round up to the nearest half

(Int([MyField]*-2))/-2

so I guess, and you had best try it since I might be talking cobblers, the following would round up to the nearest quarter

(Int([MyField]*-4))/-4

At least it might be worth trying but the more I look at it the more I am suspicious it won't work. Might spark a thought for you though
Best wishes

Excellent, that worked! THANKS

 

[Malcy]

Delighted to be of help