Help

Round up of formulated value

1696 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Site_Team
6 - Interface Innovator
6 - Interface Innovator

i need to round up the following formula
SUM({Screen Area:}/result)
what i require is any value between 0 to 0.49 to be 0.5 and any value to be between 0.5 and 1 to be 1
and so on up .

so were constantly rounding up by the nearest 0.5

3 Replies 3
augmented
10 - Mercury
10 - Mercury

I’m not sure that I understand your formula, but you could take its result and plug it in to this. Way less elegant than I hoped I could put together quickly. Someone else might come along and really embarrass me :slightly_smiling_face:

Your formula or field name = YFF

IF(YFF,ROUNDUP(YFF,0)-IF(YFF-ROUNDDOWN(YFF,0)>0.5,0,0.5),0)

thanks for your help and perhaps you can have a look at this again , for me
below is what your formula gives me and i have inserted a manual column of what i hope to get . can you have a look at this again please
image

augmented
10 - Mercury
10 - Mercury

Check the formatting tab in the formula field to make sure it is set to decimal with the correct number of places.