Skip to main content

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

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 🙂


Your formula or field name = YFF


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

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 🙂


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

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

Reply


Terms & Conditions