sharepoint计算列以舍入值 [英] sharepoint calculated column to round a value

问题描述

请帮助。



i想要计算一个字段值，如果它小于0.5则会向上舍入到0.5（例如.3将是.5,1.3将是1.5,2.1将是2.5）并且如果该值更大则1.5 ti将向上舍入到下一个整数（例如.6将是1,1.7将是2,2.6将是3）



提前感谢

please help.

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)

thanks in advance

推荐答案

尝试ROUND（origionalnumber，1）功能



喜欢

ROUND（111.198,1）== 111

ROUND（111.598,1）== 112

try ROUND(origionalnumber, 1) funtion

like
ROUND(111.198, 1) == 111
ROUND(111.598, 1) == 112

这篇关于sharepoint计算列以舍入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！