Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Round up of formulated value

649 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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