I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be round up to the next integer(ex. .6 would be 1, 1.7 would be 2, 2.6 would be 3)

How can this be done?


What you describe is a ceiling function. SharePoint does not have such a function, but you can roll your own with the Roundup function. Create a calculated column and use this (replace "TheNumber" with your number column). Ensure your calculated column is of type "Number".


enter image description here

  • Thanks for this! Very useful! – Nullldata May 14 '19 at 7:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.