Click here to Skip to main content
14,733,541 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted

1 solution

try ROUND(origionalnumber, 1) funtion

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900